Forum Discussion
Location of Power Query Files
Well, there's allways more than one way to skin a cat:
A very dirty method might be to re-name the parent folder, then go into Power Query and do a Refresh All and see what fails. 🙂
Maybe try some 3rd party tools like DAX Studio or Tabular Editor. This article introduces adding them directly into Power BI Menu and offers some links: https://powerbi.microsoft.com/en-us/blog/announcing-public-preview-of-external-tools-in-power-bi-desktop/
Best of luck.
I don't think you can specify a relative path in the File source query. But you can use a Power Query Parameter for the Folder portion.
Suppose all your files are under sub folders under C:\My One Drive with a really long path name that I don't want to keep re-typing\
Create a Parameter of type Text, with that value.
Then in each of the File Sources, substitute the literal path string with the Parameter name and concatenate the file name.
Thats sound like a good work around because if you change the parameter I assume that would change all the locations it points to.
I found a video for using this and I think I have it working for one table.
Question: if you have say seven files with "C:\My One Drive with a really long path"
Is there a way you can find all these in power query (Like a searching a text string through all the code)
Well, there's allways more than one way to skin a cat:
A very dirty method might be to re-name the parent folder, then go into Power Query and do a Refresh All and see what fails. 🙂
Maybe try some 3rd party tools like DAX Studio or Tabular Editor. This article introduces adding them directly into Power BI Menu and offers some links: https://powerbi.microsoft.com/en-us/blog/announcing-public-preview-of-external-tools-in-power-bi-desktop/
Best of luck.
