Forum Discussion

YashikaAgrawal's avatar
YashikaAgrawal
Post Patron
1 year ago
Solved

Power BI Migration – Accessing SharePoint, Databricks from other Tenant via B2B

Hi, We are working on a Power BI migration from the INFY tenant to the TATA tenant. In our current setup: SharePoint Online, Databricks is hosted in the INFY tenant. Some users have been migrated...
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Thanks for taking the time.
    1. Yes, you'll need to reassign permissions for the new guest accounts in the INFY tenant. Although the email remains the same, the underlying identity changes, so SharePoint won’t recognize them automatically. Go to the SharePoint site, then Settings-Site Permissions - Share site, and enter the guest user’s email. Make sure the guest user has already been invited to the INFY tenant before granting access.


    2. You also need to manually re add the guest users in the INFY hosted Databricks workspace. This involves adding them in the Admin Console under Users and reassigning access to clusters, SQL warehouses, tables, and DBFS folders.


    3. Since you’re using OAuth for Databricks, you’ll need to re authenticate the dataset connection in Power BI Service. Go to the workspace, then Dataset Settings- Data Source Credentials, and re authenticate using the guest account’s token.


    4. Your understanding is correct here as well. Add the guest user to the same roles as before, and if you’re using Row Level Security, ensure they’re assigned to the correct roles in the dataset security settings.

     

    Hope this helps.