CROSS-TENANT CONNECTION - Documentation

Context: A Lakehouse called "LH" has been created on Tenant A. In this Tenant A, the user "USER" is present as a guest user.

Request: The request is to connect to the LH SQL Endpoint on Tenant A (via SQL Server connector), create a Power BI model and report, and publish it to a second Tenant B (where USER is a normal user, not a guest).

Notes: All settings on Tenant A and Tenant B have been configured to allow cross-tenant data sharing and it works. However, it has been observed that if the guest user USER only has "Read"-like permissions on the Lakehouse/SQL Endpoint (set directly on the item - not added to the Workspace in a specific role), USER is unable to connect to the data. If, however, the user is added as a Viewer to the workspace where the LH is deployed, then USER is able to connect to the data.

Question:

Is there any documentation describing this specific scenario? To date, I haven't been able to find anything concrete. Also: has anyone else encountered the same situation? Have you noticed anything new/different from what is described above?

Thanks everyone! 🙂

3 comments