One report for each store

[MrPontes]

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 database that contains the data of all the stores. In the database tables, there's a column specifying which store the data is about.

Is there a way to build one single report and replicate it for all the stores, or do I have to build one report at a time (over 100 times)?

Thanks

[ibarrau · Accepted solution]

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,

[MrPontes]

Thank you, I will look into that.