Forum Discussion
Solved
One report for each store
Hello, I have the sales data of over a hundred stores, and I would like to build the same report for each one of them. The owner of the store would only have access to his report. I have one single...
Hi. Yes there is. You have to use RLS to accomplish that. Creating a role for each business or a table with the email and the business to filter the model would work. You can learn more about it here:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://www.youtube.com/watch?v=MxU_FYSSnYU
Hope that helps,
Hi. Yes there is. You have to use RLS to accomplish that. Creating a role for each business or a table with the email and the business to filter the model would work. You can learn more about it here:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls
https://www.youtube.com/watch?v=MxU_FYSSnYU
Hope that helps,
Thank you, I will look into that.
