Tenant migration, source as Onedrive

Hi YashikaAgrawal ,

Migrating Power BI content between tenants with OneDrive as a source definitely has a few gotchas. Here are some things I’ve learned from experience that you’ll want to cover:

1. Identify all OneDrive (and SharePoint) connections: Make a list of all reports, datasets, dashboards, and even dataflows that use OneDrive or any other tenant-bound cloud storage. If you have a lot, scripts or the Power BI REST API can help with discovery.

2. Repoint data sources in every PBIX: Open each PBIX in Power BI Desktop and update the data source to point to the new OneDrive path. If your files are Excel workbooks that themselves connect to other sources, make sure any internal links are also updated.

3. Permissions: Double-check that the new OneDrive files have the right permissions so Power BI can access them. If you had special sharing set up in the old tenant, recreate those shares in the new tenant.

4. Scheduled refresh: After republishing, reconfigure scheduled refresh in the Power BI Service and run a test to make sure it works.

5. Gateways: If any of these reports use the on-premises data gateway (rare with OneDrive, but possible if you have hybrid sources), update your gateway mappings as needed.

6. Workspaces & publishing: Set up your workspaces in the new tenant before republishing. Assign the right users and roles so everyone gets access as before.

7. Validate everything: Refresh all your reports in the new tenant and do a quick compare with the old ones to make sure data and visuals are still correct.

Don’t forget Power BI Apps and dashboards they’ll need to be recreated.