cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Storing Power Query M queries in Git?

So I realize many people come to Power BI from the Excel world. But I am sure there are lot's of people coming from the open source world. From our perspective a query is a little program and programs should be managed in a SCCS like Git. That way I can version queries, share them with others who can make changes and import them into whatever report I need them.

 

Here is another scenario where storing in something like Git is so important: In Excel and O365 you can store power queries in a Power BI site - but that is a disaster. I did it once, my Excel file crashed and I lost 2 hours of query work. I said to myself, great I saved them on O365 I can just reuse them - but of course all I got back was a link to some internal binary. The "original" query is stored in the Excel file but since that file crashed and burned without having a recoverable backup of the lost work - all that work went down the tubes.

 

I did find this little post online, but the approach seems to require you have the text file in a local directory, so I'm not sure its relevant for published reports on powerbi.com

 

Anyone have any good ideas besides copy/paste functions into reports?

 

If not, I will add it as a feture request and anyone interested can upvote it.

 

 

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Storing Power Query M queries in Git?

Are you referring to "Send to Data Catalog"?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Power BI Team
Power BI Team

Re: Storing Power Query M queries in Git?

Please do file this as a feature request. Of course, nothing prevents you from storing code in GitHub and copying it manually into your query -- but this is obviously tedious and error-prone. I personally keep code samples at https://gist.github.com/CurtHagenlocher

Highlighted
Helper I
Helper I

Re: Storing Power Query M queries in Git?

When I was talking about the problems I had in Excel - yes I was referring to send to Data Catalog!

 

And I have opened a request for this feature.

Highlighted
Helper I
Helper I

Re: Storing Power Query M queries in Git?

Highlighted
New Member

Re: Storing Power Query M queries in Git?

I too consider it essential to manage any source code with version control system. I was rather disappointed to find out there is no easy way to do so with Power Query.

 

That's why I have started the LibPQ project: https://github.com/sio/LibPQ/ It enables you to store source code in local files or on the web server, and to load those modules into your workbooks.

 

I hope you'll find it useful too.

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!