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.

set's avatar
set
Frequent Visitor
8 years ago

Hi v-jiascu-msft,

 

before the migration each tenant had its own workspace collection. Now, we mapped this to each tenant has its own group/workspace in Power BI Service.

 

If I'm informed correctly we can't use Power BI RLS with direct query. 

 

The tenants access their reports through the same application. The scenario is "app owns data". 

 

Meanwhile I've also contacted the Azure support. They also told me that all workspaces/groups and datasets within them, that connect to the same database server share the same gateway and datasource. Which is a bummer, since our solution was working before with the old Workspace Collection. We could assign different credentials to the same database server for each dataset. This is a very hard breaking change for us, no easy migration.

 

See: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20381530-allow-multiple-credentials-for-the-same-database-i

 

Kind regards

set's avatar
set
Frequent Visitor
8 years ago

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