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.
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
Solved! Go to 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.
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.
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.