Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!!!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |