RLS stands for Row Level Security and is a function within Power BI used to securely manage what the users see. I am reusing the steps from the Power BI embedding blog, and continuing with the same dataset to define RLS. Another big thanks to Jeroen Vos for teaching me PowerBI.
We start the process in Power BI for Desktop. Open the same report, and then navigate to Modeling and Manage Roles.
This brings up a DAX console, and I will chose the “Address 1: Country/Region”
Now we can test the DAX by simulating how it is with another user login. This function is something I wish we had in Dynamics!!!
Notice that the data has changed!:)
NB! Remember to publish changes to PowerBI.com
Log into https://www.powerbi.com to complete the rest of the process
Next step is to add a user to the newly created security role. Navigate to datasets and open the security.
Last step is to Share the Dashboard with the user
Open Dynamics 365 and add a new Power BI Dashboard.
The Administrator (All data)
The Sales user (Only USA)
RLS reporting in Dynamics 365, secure and supported 🙂