Update Path file automatic when change source file

[nmhung49]

I get data from multiple files in the same folder, but when I change the path and refresh data, I have a  error message. For example

File Path                                                        File Name

D:\OneDrive\2018\                                       A.xls

                                                                      B.xls

                                                                      C.xls

And the file get data with the path D:\OneDrive\Total.xls

When I changed File of the Path to

D:\OneDrive\2018\Data\                               A.xls 

                                                                      B.xls

                                                                      C.xls

And the file get data with the path D:\OneDrive\2018\Total.xls

When I refresh data have an error

[Datasource.error] Could not find file 😧 \ OneDrive \ 2018 \ A.xls ...

Now, I want to automatically update the Path file when I refresh the data

Currently I use fomular excel: Cell ("file name") to get the path to update change part of the path

Thanks!!!!

[v-juanli-msft]

Hi @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.

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.

You can also go to File -> Options and settings -> Data source settings >Right click data sources and change source.

Best Regards

Maggie