Moving SP 365 DataSource to new domain - how to switch connection?

[Belthasar]

Hi there, first time poster - moderately long time lurker. Thanks for being here.

My corporation is currently in the process of moving our Sharepoint Online 365 from one domain to another. I have multiple reports, and data connections pointing to the original domain. The sites containing the data has been copied over to the new domain.

When I attempt to edit the data source through Data Source Settings, and modify the URL I get the error: The Key didn't match any rows in the table.

I suspect that since everything is re-indexed on the new site, this is the cause - are there any tips or tricks to get around having to re-create all my prior work to get the BI reports to automajickally (yep, its a technical term) pull the data from the new domain site? (Same credentials used between both domains)

Thanks in advance!

[v-yuezhe-msft]

@Belthasar,

Do the table have identical structure after you move SP data source to new domain? After you change the URL, I would recommend you check each step under APPLIED STEPS in Query Editor of Power BI Desktop and then figure out which step thows this step.

Besides, you can still use the old URL, then connect to  the new URL using same sharepoint connector in a new PBIX file, go to Advanced Editor of the new query and the old query, then check if there are any differences between the code lines in each query.



Regards,
Lydia

[Belthasar]

Thank you Lydia,

The table does indeed have the same structure. I just copied out the output from the advanced editor and ran it through a file compare - the only differences were in the URL. 

I am currently looking into connecting fresh to the new datasource as you had suggested, but go through and re-run the applied steps from the original. While this isnt nearly as "pain free" as I had hoped, this may be a quick(er) way than re-do all of the reports.