Forum Discussion
Using the same query in different workbooks
Nikita,
As i understood you have several Excel files with exactly the same query which you change from time to time. It could be several ways
1) Manually change query in each file as you do now
2) Change the query in one file and copy/paste entire query into another files
3) Keep query in Azure Data Catalog and share it from it. See more details here https://blog.crossjoin.co.uk/2016/11/29/sharing-power-query-queries-with-azure-data-catalog/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+wordpress%2FCpjz+%28Chris+Webb%27s+BI+Blog%29. It's for Power BI, same works for G&T.
Perhaps the latest will work for you.
Thank you, Sergei!
Hope to see in future an opportunity of auto-updating of queries' codes.
The 3rd way works in Excel, but I dont see the same function in Power BI (I use both Excel and PBI), there is no any button about Data Catalog.
Unfortunately yes, not implemented so far for Power BI Desktop. There is the workaround to use Azure Data Catalog REST API (see here https://community.powerbi.com/t5/Desktop/Azure-Data-Catalog-Integration/td-p/562/page/2 one of the latest posts), but i have no idea how it works
Thanks again!
So, I will store all quiries in a special file and copy/paste it from here if needed and update codes from here.
The only issue here with copy/paste of the entire query it adds new one with new name, not replaces the query. If you have dependencies it's not enough just to delete old query and rename new - all references within the model will be on old one.
I'm not sure if it's possible to replace the query with such approach.