Forum Discussion
Embedded and direct query: All groups have the same gateway and datasource
I have solved this now by adding a DNS alias for each tenant to the Azure SQL Server.
Hi set,
If I understand your scenario correctly, you used many tenants in the old embed type while only one tenant in the new embed type. Yes, all the workspaces share the same gateway. The solution could be using Power BI RLS instead. What's your embed scenario exactly?
1. Do the end users share the same application (software)? If they don't share the same application, you can embed different reports for each applicatioin.
2. Users own data or App owns data?
Best Regards,
Dale
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.
Kind regards
I have solved this now by adding a DNS alias for each tenant to the Azure SQL Server.