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

Nolan Tripp

Copper Contributor

Apr 10, 2017

Hello Nikita.

I'm not sure if the link below will help but I wanted to respond because I have a similar situation and think it is going to work for me. I'm not affiliated with the website or anything, just another Excel enthusiast trying to learn how this new stuff works.

http://powerbi-pro.com/reuse-your-queries-in-power-bi/

Nikita Chemeris
Copper Contributor
Apr 18, 2017
That is what I need! Thank you!
SergeiBaklan
Diamond Contributor
Apr 11, 2017
Hi Nolan,

Yes, that's a good point, thank you. Just in case two more related topics (not exactly about the sharing)

1) Edit external files better using Notepad++ with installed M-script definitions, google easily gives more details
2) How to export all or group of queries at once (e.g. for documenting) there is another Chris' post https://blog.crossjoin.co.uk/2017/02/25/exporting-your-queries-m-code-from-power-query-and-power-bi-using-copypaste/