Forum Discussion
Power BI with Databricks
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.
Thanks for the reply, We have RLS in reports, we are using OAuth, will the Service principal works..
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.You can use Guest Users Azure AD B2B from Tenant B in Tenant A so OAuth passes user identity and RLS works correctly.
Can you please explain this step... Thanks,
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.