Forum Discussion

nathanhanser's avatar
nathanhanser
New Member
10 years ago

Variable or Parametering Report based on Log in

Hello,   I am looking to build a report that is specific to each user that is logging into powerbi.com/sharepoint.   I was wondering if there was a way to build a filter/variable/parameter to fil...
Need Help
Tips and Tricks
Tutorial Requests
HarrisMalik's avatar
HarrisMalik
Icon for Continued Contributor rankContinued Contributor
10 years ago

nathanhanser what you are looking for is row level security which can best be defined in SSAS (Multidimensional or Tabular). This way when user logs in to powerbi.com and open the reports he will see only what he is allowed to see.

 

Regards

Harris

greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident Rockstar
10 years ago

Responding to HarrisMalik, I would like to emphasize that SSAS is not just the best way to define role-base / row-level security, it is the *only* way to do so currently for reports in the Power BI Service without using preview features.

 

If willing to use the Enterprise Gateway, then row-level security can be implemented natively in SQL Server 2016, Azure SQL DW, and Azure SQL DB.