Updating Data sources after migration

Hi YashikaAgrawal 

Thank you for reaching out to the Microsoft Fabric Community Forum.

When migrating users from Tenant A to Tenant B while keeping Power BI reports in Tenant A, the key changes involve updating data source paths and re-authenticating connections. For SharePoint and OneDrive, the new tenant URLs must be updated directly in Power Query (Advanced Editor) within Power BI Desktop, as modifying only the Data Source Settings is insufficient since the URLs are embedded in the query M-code. After updating, clear existing permissions in Data Source Settings, re-authenticate with the new Tenant B account, and then republish the dataset to the Power BI Service. Once republished, the Data source credentials option in the Service will be available, where you should re-authenticate to enable scheduled refresh. For Databricks, since the environment remains in Tenant A, no path updates are required; however, it is essential that the connection uses OAuth2 authentication instead of username/password or access token, as only OAuth2 enables credential management in the Service. If necessary, reconnect to Databricks in Power BI Desktop using OAuth2, then republish and re-authenticate in the Service. Going forward, it is highly recommended to parameterize the SharePoint and OneDrive tenant URLs in Power Query, so that any future tenant migrations or link changes can be managed by updating a single parameter rather than modifying multiple queries individually.

I hope this information is helpful. . If you have any further questions, please let us know. we can assist you further.

Regards,

Microsoft Fabric Community Support Team.