Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have such scenario:
- I have a multi-tenant SQL database deployed in Azure (Azure SQL Database)
- Each table in the DB has a column "TenantId", meaning to which tenant does the data in that row belongs to
- I want the tenants to have an abillity to create their own Power BI reports, however, they should only have access to their specific data (based on TenantId column)
I want to achieve something like this:
So, I've been reading about Multitenant applications, but I don't really need the embedding. To further elaborate, what I need is probably just a separate workspaces for different tenants, with datasets filtered to only their data. I've thought of 2 potential ideas:
The first approach was fairly simple, but let's say I will have to manage 100 tenants, that would mean I need to update 100 files manually if there's some changes? The second approach I was not able to correctly set permissions in Power BI Service. The user I invited into the workspace was able to view data for every role.
I will appreciate any feedback on this matter.
Thanks
The user I invited into the workspace was able to view data for every role.
RLS is ignored for any workspace users above "Reader" level.