Update Path file automatic when change source file

Question

I get data from multiple files in the same folder, but when I change the path and refresh data, I have a&nbsp; error message. For example&nbsp;File Path&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; File NameD:\OneDrive\2018\&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A.xls&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B.xls&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C.xlsAnd the file get data with the path D:\OneDrive\Total.xlsWhen I changed File of the Path toD:\OneDrive\2018\Data\&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A.xls&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; B.xls&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; C.xlsAnd the file get data with the path D:\OneDrive\2018\Total.xlsWhen I refresh data have an error[Datasource.error] Could not find file D: \ OneDrive \ 2018 \ A.xls ...Now,&nbsp;I want to automatically update the Path file when I refresh the dataCurrently I use fomular excel: Cell ("file name") to get the path to update change part of the path&nbsp;Thanks!!!!&nbsp;

v-juanli-msft · Answer

Hi&nbsp;nmhung49
As searched and tested, it is impossible to refresh the dataset and chane the data source path at the same time in Power BI currentlly.
When you click on "refresh" button, it will refresh the data from the exsiting data source file via data connection.
&nbsp;
To select different data source files for the report,
You could go to query editor, select your table and on the right hand side under Applied Steps click settings icon.

&nbsp;
You can also&nbsp;go to File -&gt; Options and settings -&gt; Data source settings &gt;Right click data sources and change source.
&nbsp;
Best Regards
Maggie
&nbsp;
&nbsp;
&nbsp;

Forum Discussion

Update Path file automatic when change source file

1 Reply

Related content

Monthly Automatic Change

Year updated automatically

Automatic refreshes never pull in changes (UPDATED)

Onedrive automatic update does not work

How to update shared expression automatically?