CODEWITHSUNDEEP
powerbiazure-sql-databasepowerbi-datasourcemicrosoft-fabric
Ahmed
Ahmed

Reputation: 35

PowerBI get data from different tenant SQL database

What is the best way to access Tenant A SQL database hosted in Azure from Tenant B PowerBI?

Tenant A provides service and hosts client databases.

Databases in Tenant A: client-A-DB, client-B-DB, client-C-DB, ...

Tenant A does not have PowerBI. Each client will create PowerBI report in their respective tenant however, they need access to data hosted in Tenant A.

Thanks

Upvotes: 0

Views: 57

Answers (1)

David Browne - Microsoft
David Browne - Microsoft

Reputation: 89361

Tenant A will need to provision an identity for Power BI to use. That can be a SQL Login/Password (Power BI calls this "Basic"), an Entra ID Service Principal, or an Entra ID Guest User.

enter image description here

Upvotes: 0

Related Questions