Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

SaaS and Multi-Tenancy combined with Direct Query against Oracle in Power BI Embedded report

Hi,    We are developing a large SaaS application with the multi tenant, single database pattern (Oracle). We have a tenant-id column in all database tables, which are separating the tenants. How ...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Thanks a lot! 

     

    Very useful topics for me! :-) I will dig into this!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi, and thanks for the respond!

 

Unfortunately the tenant-id is a unique number. Technically it is's comming from an Oracle Sequense that gives all the primary keys (tenant-id) a unique value in the rows (and the foreign keys, which will be the filter columns).

 

We have over 1000 tenants in the database. With RLS we then need to create a role for each tenant? It seems that it will be much manuel work to maintain.

 

Is this the only way to filter rows?

 

 

Reagrds

Aslak

v-micsh-msft's avatar
v-micsh-msft
Microsoft Employee
8 years ago

Thanks for the explanation, specially for the tenant part.

 

>>With RLS we then need to create a role for each tenant?

 

 

If you would like to filter rows by the tenant ID, then yes, you may need to create a role for each tenant.

 

>>Is this the only way to filter rows?

 

 

That mostly depends on what you would like to filter with.

 

You may also take use of Power BI Javascript SetFilter function:

See:

Filters

https://github.com/Microsoft/PowerBI-JavaScript/wiki/Filters

 

Regards,

Michael