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?
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