Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

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

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!



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.



Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors