question

MSUser424525 avatar image
0 Votes"
MSUser424525 asked MOXiMOX-2301 answered

Connecting Power BI from one tenant to Azure in another tenant

Is there a way of connecting Power BI from one MS tenant to an Azure SQL database in another tenant? Or do they both need to be in the same tenant?

azure-sql-databaseazure-ad-tenant
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MOXiMOX-2301 avatar image
0 Votes"
MOXiMOX-2301 answered

If you want to be able to access data from one tenant to another with a user in one aad then you need to establish trust or use the cross-tenant features.

https://docs.microsoft.com/en-us/azure/active-directory/external-identities/cross-tenant-access-overview

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MOXiMOX-2301 avatar image
0 Votes"
MOXiMOX-2301 answered MSUser424525 commented

You can connect powerbi to anything is the simple answer. It is not dependent upon data sources being present in azure full stop.
So as long as you have an api, gateway, etc and the appropriate permissions then you can connect. In powerbi desktop you can assign multiple datasources and there is support to make the connection strings to hundreds of types of sources.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I'm not sure if the answer would be different but if I'm using Azure Active Directory (cloud based) in one tenant, could I then connect powerbi from another tenant to this cloud based database?

0 Votes 0 ·