Migrating PBIX files from one tenant to another in Office 365

[aaroh_bits]

Hi All, 

• We need some tool that can help in migrating a PBIX files from  one tenant to another in Office 365. 
• there are aroud 50-80 PBIX files needs to be migrated. 
• Q: Do we have any tool that can help? 
• Q: Do we need to change data connections of PBIX file to another tenant manually? 

Please advice the best pratice for this senecrio. Thanks in advance 

@v-easonf-msft @Greg_Deckler  @GilbertQ 

[v-shex-msft]

HI @aaroh_bits,

AFAIK, current you can only do migration operations between workspaces.

Duplicating workspaces by using Power BI cmdlets 

I think this operation should more related to the office instead of power bi, You can take a look at the following blog if it helps to your requirement: (notice: I checked the power bi documents but haven't found any solutions to solve your requirement) 

Microsoft 365 Tenant to Tenant Migration – Tips and Methods 
Regards,

Xiaoxin Sheng

[Greg_Deckler · Accepted solution]

@aaroh_bits - The exact guidance here is going to depend on a whole host of factors. In terms of data connections this shouldn't matter for example if all of the data sources are on-premises for example. You may have some luck with the Power BI REST API in exacting all of the files but for 50-80 files, I would probably just brute force it. Go to report, download PBIX, open PBIX, publish to new tenant. Brutally manual but you could probably knock it out in a day or two.

[aaroh_bits]

Thank you so much @Greg_Deckler . and thanks every for your amazing suggestions. Really apprecaite it. 

[GilbertQ]

Further to what Greg said, I would make sure you either have already got all the PBIX files or that you can download them from the Power BI Service.

I have seen some situations where they cannot access the PBIX for different reasons!

But it would be a manual process or could use the Power BI REST APIs