Forum Discussion

mwjansen's avatar
mwjansen
Helper I
1 year ago
Solved

Smartsheet File moved to another folder

In creating a report, I pull data from Smartsheets (via Get Data). Three of the smartsheet grids were moved to another folder by admin, and they won't be put back.    Now a refresh in Desktop says ...
Need Help
  • MohamedFowzan1's avatar
    MohamedFowzan1
    1 year ago

    Hi mwjansen 

     

    - Go to Home → Transform Data → Advanced Editor for each affected query pulling from Smartsheet.

    - Look for any hardcoded folder paths or URLs referencing the old folder.

    - Replace the old folder path

    - After updating the folder paths, refresh the preview in Power Query Editor.

    - Ensure the tables load correctly with data from the new folder. Also make sure the schema has not changed, if they have accoringly change column names or remap relationships

    - Make sure the admin knows the impact of changing the folder and yes parameters would help if you would often change the locations used.

MohamedFowzan1's avatar
MohamedFowzan1
Super User
1 year ago

Hi mwjansen 

 

- Go to Home → Transform Data → Advanced Editor for each affected query pulling from Smartsheet.

- Look for any hardcoded folder paths or URLs referencing the old folder.

- Replace the old folder path

- After updating the folder paths, refresh the preview in Power Query Editor.

- Ensure the tables load correctly with data from the new folder. Also make sure the schema has not changed, if they have accoringly change column names or remap relationships

- Make sure the admin knows the impact of changing the folder and yes parameters would help if you would often change the locations used.