PowerQuery

[Paddo2010]

Hi, I am new to Power query and while I am able to use it for what I need to do, I can’t seem to figure out how to save a query for future use. I was wondering if it’s possible to save a query for future use just like saying a macro and running it in a different file. If yes, how do so go about it please. Thank you

 

[alansidman]

Power Query saves the query in the Excel file it is located in. You could save it in a blank file and create a parameter for the path to the file you want to query. This will allow you to update the existing query with the new source file. Here is one example of how to achieve this.

Create Dynamic File Path in Power Query - Goodly

Create a dynamic folder or a file path, both in Excel Power Query and in Power BI. Create Dynamic File Source in Power Query

goodly.co.in

 

[Paddo2010]

Power Query saves the query in the Excel file it is located in. You could save it in a blank file and create a parameter for the path to the file you want to query. This will allow you to update the existing query with the new source file. Here is one example of how to achieve this.

Create Dynamic File Path in Power Query - Goodly

Create a dynamic folder or a file path, both in Excel Power Query and in Power BI. Create Dynamic File Source in Power Query

goodly.co.in

Thank you for your quick reply. Your response is extremely helpful. Following the video, I got the error message below, do you happen to know how I can fix it

DataFormat.Error: The supplied folder path must be a valid absolute path.

https://work-my.sharepoint.com/personal/user_work/Documente/Desktop/Test/Queries.

I changed part of the pathname so that my office name isn’t on here. Thank you

 

[alansidman]

I think it has to do with Sharepoint. I don't use Sharepoint, but I have seen some posts indicating that it sometimes does not play well with PQ under certain situations. You will need to do some research.

 

[Paddo2010]

I think it has to do with Sharepoint. I don't use Sharepoint, but I have seen some posts indicating that it sometimes does not play well with PQ under certain situations. You will need to do some research.

Ok, thank you for all your help. I really appreciate it