Refresh File Change folder

[readyOH]

Hi,

My powerbiDesigner dataset is an excel file stored in my PC (My Documents folder). In PowerBi Designer I have edited some reports, and now I want to change the file destination (new file with same name, same structure)

When I refresh data, it always search in the same directory (MyDocuments). I can not use the new file in the new folder because PowerBi search automatically in the same folder.

How can I specify the new folder?

thanks

[Rémi · Accepted solution]

Hi,

You have to change your request manually, it's the best way in order to keep the steps.

Open your query editor, do a right click on your request then choose Advanced editor. If you read the first line, you will se something like that :

Source = Excel.Workbooks("FilePath/Filename.xlsx")

Change the source, validate and it's done.