Forum Discussion
Solved
Power BI with Databricks
Guys, In power bi, we are in process to migrate from Tenant A to tenant B, is it possible "we migrating Power BI reports to Tenant B, but the Databricks data source remains in Tenant A. we are us...
Service Principal may not support user-based RLS because it uses app-only authentication.
You can use Guest Users Azure AD B2B from Tenant B in Tenant A so OAuth passes user identity and RLS works correctly.In Tenant A's Azure AD, invite users from Tenant B as guest users.
Assign these guest users the necessary permissions in Databricks (workspace, cluster, SQL warehouse).
In Power BI (Tenant B), connect to Databricks using OAuth and authenticate with the guest user's credentials.
Publish and test the report. RLS should work as the guest user's identity is passed through OAuth.
Yes, it's possible — but OAuth won't work across tenants. Use either:
- Service Principal: Register a service principal in Tenant A and grant it access to Databricks. Use it in Power BI in Tenant B.
- Guest User: Invite a user from Tenant B as a guest in Tenant A, assign Databricks access, and use that account in Power BI.
Best Practice: Use a Service Principal for scalable and secure access.