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