How to manage multi-tenant data source in Power BI?

[pej]

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:

1. For each tenant, create a dataset with filtered tables (by TenantId column)
2. Create some "master" dataset, create roles for each tenant, where each role would have access only to data it got assigned 

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

[lbendlin]

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.