Question

You maintain a Power BI report that imports CSV files from a network folder. The finance team frequently relocates the source folder between quarters, and each time you must manually edit multiple query steps to update the path. You want a maintainable approach where the folder location can be changed in one place without editing individual query steps. Which Power Query feature should you implement?

Accepted Answer

Create a text parameter for the folder path and reference it in the Folder.Files source step

Answer

Duplicate each query and hardcode the new path so the original queries remain unchanged

Answer

Enable the 'Detect data type' option so Power BI automatically finds the moved files

Answer

Use the Manage source settings dialog to clear the credential cache each quarter