Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
This is a really good idea.
I have so many queries with so many functions (as M-code), across workbooks.
If I could maintain the functions in a Git, and just import them into the relevant workbooks, or dataflows (as a query that pulls in another query), it would save so much code duplication.
For example now, if I have to modify one function, and I have 20 excel workbooks, I have to modify that function 20 times.
Microsoft already do this for LAMBDAS, and normal excel formulas. I think, they should do it for Power Query and M-Code scripts too.
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.
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
Are you referring to "Send to Data Catalog"?
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.
Here is the link for those who want to upvote:
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
30 | |
20 | |
19 | |
13 | |
13 |
User | Count |
---|---|
28 | |
18 | |
18 | |
16 | |
14 |