Forum Discussion
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 ...
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.
Perfect. Saved me so much time. I'll have to go learn about parameters now.