cancel
Showing results for 
Search instead for 
Did you mean: 
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

Accepted Solutions

Re: Dashboard security for mulitple users

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

Re: Dashboard security for mulitple users

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

Anonymous
Not applicable

Re: Dashboard security for mulitple users

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

Highlighted
Karenp426
Frequent Visitor

Re: Dashboard security for mulitple users

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.

kmcallister
Frequent Visitor

Re: Dashboard security for mulitple users

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

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.