How Do You Migrate A Data Source to A New SharePoint Site Automatically!?

[aziegele]

 Hello,

When changing the data source from one SharePoint site to another I receive an error that says "The key didn't match any rows in the table." I am able to do the manual work around for this issue, but have to do it for each report with every list I am migrating. FYI, both SharePoint sites have the same data model.

The issue is that we have to many reports to do these manual steps every time for each report? Is there any way to automate this process? Could a powershell script fix this issue somehow? Any help to point me in the right direction is greatly appreciated!

Thanks!  

[v-chuncz-msft]

@aziegele,

You may try to check code in The Advanced Editor.

[aziegele]

@v-chuncz-msft Thanks for the response,

Do you know if I am able to edit multiple lists queries at a time in Advanced Editor? I only see that I can edit one query at a time.