Changing data source errors

[Matthias93]

Hi,

I currently have a dashboard based on some SharePoint lists and some excels. I am trying to change the data source of the SharePoint lists to a new SharePoint site. If i do this through the advanced editor it get the error message as shown in the screenshot. I then tried to change source and the navigation in the 'applied steps' section of the queries. This however gives me errors saying that the 'ID' column cannot be found since I changed the name of the ID columns since I was getting error in the first place saying that there already was an ID column in other queries. If I take out the step where I changed the ID name I of course get errors in my following query steps which use the new ID column name.

Has anybody got an idea on how to get this solved, I'm getting quite desperate and don't feel like rebuilding my entire dashboard from scratch.

Kind regards,

Matt

[Greg_Deckler]

I would go into Advanced Editor and copy your query out to Notepad or something like that. Create a new query to the new source and start going through the same steps and see if you can replicate your query. You can paste in code from your old query when you feel that you get to the point that things are working but first step is to make sure that you can connect to your new list successfully and go through your steps. You can always rename your queries to get them in the right tables.

[Matthias93 · Accepted solution]

I solved this issue by going to the step where it started to go wrong. I noticed there was always a step where the ID column was changed to ID.1, by changing this ID.1 to ID in the advanced editors all my issues went away.

Thanks for helping

Regards,

Matthias