Changing excel data set path way

[Anonymous]

Hi, so I have am excel dataset for my report and I just had a little clear out of my files and decided to reorganise but it seemed to have cause an issue with my report in desktop. 

Does the location of the excel file have to stay in the same area at all times?

I did try to update the file path but it was just not sorting the report out.

Also, does changing the name of the report and then publishing have any affect on how it works?

[Anonymous · Accepted solution]

@Anonymous 
We can not read the error message in the image. To change the tables on a same spreadsheet you need to double click the navigation steps and choose others table in the file. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Has this file been deleted or is it because its been moved because its telling me two tables are from a different area same report but theyre all on one spreadsheet. 
Not sure whats going on 

[amitchandak]

@Anonymous , if you have changed file name or column name, You have to handle those. You can correct location from transform data -> edit data sources

Abstract Thesis:How to Change Connection Details https://www.youtube.com/watch?v=59PUFuuCrbY

How to manage when column is added or removed at source: https://www.youtube.com/watch?v=h0yLtceT0i4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=2

[Anonymous]

Thanks I will check out the video but it literally will not pick up the same file weirdly