Forum Discussion
How to bulk change the source location for queries from different files in the same folder?
Thank you Jorge. I found this article works and solves the problem.
https://powerbi.tips/2016/08/using-variables-for-file-locations/
Adding the back slash at the end of the copied file path saves my day. Preciely the line below:
= Excel.Workbook( File.Contents( Folder & "2000 Medals.xlsx") , null , true )
Thank you Jorge to give me the hint and confidence working in this direction.
hi Jorge,
Many thanks for the quick reply.
Could you stipulate how it works? Or help google an relevant article or video?
i tried and failed.
I get below:
at point 1, the parameter is used. at point 2, it is still with the raw folder path.
If i replace the folder path with Source, I get an error.
Thank you Jorge. I found this article works and solves the problem.
https://powerbi.tips/2016/08/using-variables-for-file-locations/
Adding the back slash at the end of the copied file path saves my day. Preciely the line below:
= Excel.Workbook( File.Contents( Folder & "2000 Medals.xlsx") , null , true )
Thank you Jorge to give me the hint and confidence working in this direction.
You're welcome 🙂 Well done!
