Power BI dynamic filtering according to user account

Question

I want to develop indicators using Microsoft Power BI.

I have a Datawarehouse on SQL Server and I directly query from the DW.

I would like to display different information according to the user accessing the report. I didn't find a way on how I can dynamically filter the data according to the user account.

Is it possible? If not, then what are the possible solutions to do it?

Answer 1

I believe what you are looking for is Row-Level Security and it is out with Sql server 2016 and Azure Sql DB, check here: https://msdn.microsoft.com/en-us/library/dn765131.aspx

I too have been looking for a similar solution to the same problem, I am using Azure SQL DW and I have been told the Row-Level Security will be coming to AzureSQLDW with GA, but not sure of the date on that.

So back to your question as far as I know the only possible solutions would be to use Sql 2016 Row-Level Security or you can also use SSAS in front of your data warehouse.

Hope that helps.