Forum Discussion

set's avatar
set
Frequent Visitor
8 years ago
Solved

Embedded and direct query: All groups have the same gateway and datasource

 We are currently migrating from the old PowerBI Embedded Workspace Collection to the new PowerBI service. For each of our tenants, we have a Group (formerly Workspace) in which we set the connectio...
  • set's avatar
    set
    8 years ago

    I have solved this now by adding a DNS alias for each tenant to the Azure SQL Server.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi set,

 

- what kind of datasource do you use (Azure Sql, on-premises SQL, etc)?

- do you have one database for all tenants or one database for each?

- do you use any connection parameters in the reports

 

You may read my blog post on how we tackled the multitenant scenario. You may find some useful code in there.

 

Regards,

 

Thanos

 

 

set's avatar
set
Frequent Visitor
8 years ago

Hi Anonymous,

 

- We use Azure SQL as database

- It's one database for all tenants. But each tenant has its own credentials. We use RLS on SQL level (not to be mistaken with PowerBI RLS).

- The connection string and credentials of the database are set as it is documented in the link of my initial post

 

 

PS: For some reason my reply always gets marked as spam. I hope that there won't be any double-posts

 

Kind regards