Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to 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-
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-
User | Count |
---|---|
11 | |
9 | |
4 | |
1 | |
1 |