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

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