Skip to main content

Power BI

Completed

Built in Git support in PowerBI Desktop

Vote (3223) Share
Matt Smith's profile image

Matt Smith on 28 Feb 2019 17:19:38

When you create a PowerBI report in Power BI Desktop it transparently create \ use a git repository. So you just worked normally, then when you hit publish, it actually push to remote.

Gitignore could be used to exclude data from being published to the repository. PowerBI would have version control which is desperately needed.

This would work well with the whole Microsoft buying Github \ Azure DevOps, both from the perspective of promoting good practices such as code version control and CI\CD - process of developing in development and promoting to UAT\production

It would also allow IT to get visibility of code, allow tests to be run - such as moving DAX calculated columns with M

This would also solve the other ideas:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17523715-report-version-control


https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7861287-dataset-report-version-control

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34315045-seamless-version-control-of-queries-data-model-st

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9677517-source-control

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9080776-using-git-or-some-other-sccs-to-store-m-queries-n

Administrator on 06 Dec 2023 16:56:47

Released for public preview in June 2023: https://powerbi.microsoft.com/en-us/blog/deep-dive-into-power-bi-desktop-developer-mode-preview/

Update 10/17: This is now in our upcoming roadmap and we will share more details in the coming months. Mo

March 2022 update: We are working on this item but no timeline can be shared yet. We appreciate your patience

Comments (82)
Matt Smith's profile image Profile Picture

Roger Eyre on 17 Mar 2022 17:34:49

RE: Built in Git support in PowerBI Desktop

This is long overdue from MS for PowerBI, Databricks sync to GIT from its web UI, its seemless, very little need to delve into GIT itself. The emphasis seems to be on GitHub now.

Matt Smith's profile image Profile Picture

Laurentiu Diaconu on 10 Feb 2022 14:54:46

RE: Built in Git support in PowerBI Desktop

@admin, can you please merge the following idea into this one as well since this has more votes?https://ideas.powerbi.com/ideas/idea/?ideaid=c73d887d-042e-4ca0-8216-bcb09bd282ab#idea-comments

Matt Smith's profile image Profile Picture

James Latane on 07 Feb 2022 13:44:41

RE: Built in Git support in PowerBI Desktop

It's pretty telling that this idea only comes up through a Google search - searching "Git" in the Power BI ideas search box does not show this idea as a result, nor does this idea show as a Top idea even though it clearly has enough votes. Either listen to your users and implement this idea or delete it and stop wasting everyone's time, MS.

Matt Smith's profile image Profile Picture

Laurentiu Diaconu on 10 Jan 2022 21:23:55

RE: Built in Git support in PowerBI Desktop

@admin, could you please merge all the following ideas into this one? Clearly we need all the votes we can gather here…

- https://ideas.powerbi.com/ideas/idea/?ideaid=9471d44a-03f2-45b1-a9aa-7207428eee40
- https://ideas.powerbi.com/ideas/idea/?ideaid=8875a98d-4786-48ea-a084-56708b86b034
- https://ideas.powerbi.com/ideas/idea/?ideaid=f07d934e-b56b-4e04-bcf6-28709a1494d1
- https://ideas.powerbi.com/ideas/idea/?ideaid=e0bc3bc4-9509-ec11-b76a-281878de77da
- https://ideas.powerbi.com/ideas/idea/?ideaid=0178709c-a7b9-eb11-89ee-281878de0321

Matt Smith's profile image Profile Picture

Laurentiu Diaconu on 10 Jan 2022 20:52:57

RE: Built in Git support in PowerBI Desktop

It is crazy and disheartening at the same time to see how the Power BI product team effectively ignores the developer community and only gives half baked solutions to a problem that is so natural to fix in modern software development.

There are other ideas shared on this forum which received less support than this one, but they were managed an awful lot better (communication!) and some of them even delivered… All while this is left in the dark, only for people to cry again about it when they remember how bad this all is.

It is nuts that Microsoft is fine for the community to invent “solutions” like https://github.com/synchrotech/powerbi-source-control which are obviously potentially dangerous and ship features like “Deployment Pipelines” which greatly limit what you can do with a workspace (very very limited for ISVs that have non production workspaces which are general and production workspaces which are client specific!!!).

Microsoft, would you please come to your senses and do something about this? The dataset can already be supported as a bim file (your other tool does it!!!), and I am having a hard time believing you cannot find a way to break down the report pages in something which can at least be read.

Other tools like Looker are stealing the show here since they are code first and there is only so much we can do to retain using Power BI when there are clear competitors out there which are prepared when it comes to DevOps. You are not.

Matt Smith's profile image Profile Picture

Musaab Shirgar on 25 Nov 2021 13:46:43

RE: Built in Git support in PowerBI Desktop

Git support is really important for teams who are working on the same PBix file at the same time. Microsoft needs to focus on this issue

Matt Smith's profile image Profile Picture

Daniel Byrne on 25 Oct 2021 21:04:37

RE: Built in Git support in PowerBI Desktop

The inability to version PBIX file in source control is a major oversight and a black eye on PowerBI.

Matt Smith's profile image Profile Picture

on 30 Sep 2021 22:31:42

RE: Built in Git support in PowerBI Desktop

When one saves a PBIX file in PowerBi, it would be awesome if it could automatically save a BiM file with the same name as PBIX file. Ideally, this should be an option that only those that want to turn it on, could turn it on.

This would benefit developers who use source control (like GIT), as a BiM file would automatically get created and developers would check it in. This file could also be linted and deployed if one wanted.

Matt Smith's profile image Profile Picture

on 30 Sep 2021 22:31:41

RE: Built in Git support in PowerBI Desktop

Hi Team,

in my former BI Tool, i had the possibility to embed/include external text files - for Power BI Dataflows this would be POWER QUERY Scripts - from sources like github, gitlab or azure dev ops git repositories.

I would love to see this feature in dataflows as this would make a hugh step forward for maintanance of dataflow definitions and collaborative work.

Let me know your thoughts?

Best regards Philipp

Matt Smith's profile image Profile Picture

on 30 Sep 2021 22:02:06

RE: Built in Git support in PowerBI Desktop

Hi Team,

We want some help in figuring out how to co-author power BI dashboards that will allow us to check in, check out the pbix file when we make edits/updates to the file.
1) I want to author i.e., make the edits using the Power BI desk top tool
(2) Not have to download and upload the file and
(3) have version control, ability to view previous versions etc. All Standard collaboration features for multiple analysts to co-author Power BI files and be able to publish to a workspace for consumption by a larger audience.

Thanks,
Santhosh.

Merged Idea (6)