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.

Shahid12523's avatar
Shahid12523
Community Champion
1 year ago

🔁 Yes, you can redirect Power BI to the new Smartsheet folder.
Just update the Sheet IDs in Power Query to point to the new grids.
Make sure the column names and data types match the old ones to avoid breaking visuals or relationships.


✅ Use parameters for easier future updates.
No need to rebuild your model — just swap the source smartly.