Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Karenp426
Frequent Visitor

Dashboard security for mulitple users

I have created a dashboard which uses regions as a filter.  We don't want one region seeing another region's sales and revenue numbers.  Is it possible to do security at this level so I can upload the dashboard to the server and when a regional manager accesses the dashboard, he will only see his regions information?  If so, how do I do this?

1 ACCEPTED SOLUTION

You need to use the row level security at the databaselevel to filter the region's sales and revenue. Refer this - https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security  

you could also refer this thread to get general info how you cna do this- 

https://community.powerbi.com/t5/Report-Server/How-to-use-SSAS-with-Dynamic-RLS-as-a-data-source-for...

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Hi Karenp426,

 

As you have posted this on the Report Server thread I'm guessing you are using ReportServer to publish your PBIX?

 

If so then RLS is not currently supported. We want this feature as well, but the Oct 2017 release of the Report server (the latest available) does not support this.

 

We are experimenting with using SSAS Tabular as the data source, this does support RLS and thus appears to allow you to achieve your goal. But you need SSAS, and domain users.

 

Hope this helps.

 

Kind Regards

Rob

Thank you Rob.  Yes we are using ReportServer on Prem.  I appreciate the heads up. My director won't be happy to hear that it doesn't work currently.  We seem to be having several issues with On Prem.  We aren't able to use Cloud right now and the version differences are driving us crazy.  I will look into your suggestion - maybe I will just create SSRS report and call it good.

One solution we found for RLS is to bring in another table with the correct parameters( IE. Username, RegionKey). In our case, we used Username (AD Username) and then embedded the dashboard in our sharepoint site. We then used Sharepoint to pass the URL with the username. This allowed us to display the correct dashboard to the correct user.

 

Below is the URL we are using to filter the dashboard. Add this after the dashboard path

?rs:Embed=true&filter=RestaurantSecurity%2FPARAMETER%20eq%20%27USERNAME%27

 

Hope this helps.

Kevin

You need to use the row level security at the databaselevel to filter the region's sales and revenue. Refer this - https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security  

you could also refer this thread to get general info how you cna do this- 

https://community.powerbi.com/t5/Report-Server/How-to-use-SSAS-with-Dynamic-RLS-as-a-data-source-for...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.