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

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
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications