Data Source Folder Change Issue

[Anonymous]

I am trying to change the folder from one source to another. Error when I change the folder location, wherein the correct .xlsx file is located:

This same error exists across every Query when I click into one. Please can someone suggest a solution?

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

It is useless to simply modify the path of the folder, you also need to manually modify each query above.

The easiest way is to delete this data source and reconnect to the new data source.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

The shown step is referencing a previous step - LastStep.  Does that step return a single date/value (e.g., Drill Down)?  If not that is causing the issue.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[amitchandak]

@Anonymous , some issue is happening, while you are changing. Can you try to use edit Data Source Setting and change there.

[Anonymous]

@amitchandak yes I have attempted to change via Data Source Setting, same issue