Forum Discussion

Copper Contributor

Mar 28, 2017

Using the same query in different workbooks

Hello, friends! Could you give me a piece of advice with Get&Transform please? In our company we have to use the information about sales in different reports, so I have some different excel files f...

BI & Data Analytics

Need Help

SergeiBaklan

Diamond Contributor

Mar 28, 2017

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.

Nikita Chemeris
Copper Contributor
Mar 28, 2017
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.
- SergeiBaklan
  Diamond Contributor
  Mar 28, 2017
  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
  - Nikita Chemeris
    Copper Contributor
    Mar 31, 2017
    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.