Share via

Connecting Power BI from one tenant to Azure in another tenant

MSUser424525 21 Reputation points
2022-05-17T22:20:22.707+00:00

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 Database
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
21,426 questions
0 comments
Accepted answer
  1. Magnus Oxenwaldt 166 Reputation points
    2022-05-17T22:46:42.117+00:00

    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://learn.microsoft.com/en-us/azure/active-directory/external-identities/cross-tenant-access-overview

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Magnus Oxenwaldt 166 Reputation points
    2022-05-17T22:32:08.707+00:00

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.