PowerBI get data from different tenant SQL database

Question

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

Answer 1

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.