2701
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
STATUS DETAILS
Needs Votes

Comments

M

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.

M

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

M

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.

M

It would be very useful for enterprise development teams to be able to branch a data model from an existing pbix file (or the service) and then make changes such as relationship definition, measures etc and merge them back into the file. It would allow multiple developers to work on a single model and resolve conflicts as they arise.

M

This would require the ability to export the report (no data, no Power Query*) from the Power BI file as it's own git friendly file type. This would then allow full version control. It may also require a "dataset" included template. Which would be a everything in the current template method, but git friendly format. *like a PowerBi report that connects to a data set in PowerBi service.

M

Exactly how many votes are needed to get this on the roadmap?

M

"Git connection can also enable parallel editing of a pbix file". +100 for that. Parallel editing is the main reason for push back from users during migration from competitive product

M

Linting: Its the process of running automated code analysis tools to check for potential errors. Because BiM is a son file, one could run checks to make sure that one isn't checking in code smells (example: auto date time, CamelCased visible fields, etc). Today, the above process can be implemented using Tabular Editor. The problem with TE is that users have to manually run it. Instead if the file was output automatically everytime one saves the PBIX file, then you will see it as a change and you would check it into source control with your pbix file. You could then run TE's Best Practice Analyser as the linter on the BiM file and flag issues.

M

Git connection can also enable parallel editing of a pbix file

M

@Craig Schupp - that's pretty much exactly what save-as pbit (Template) file does. But there's more to VCS than simply keeping old versions around ... that's just backup. The key enabler of VCS that revolutionises team software development is branch and merge. To be able for two people to start with the same version, each make independent changes, and then to identify the changes and merge them together into a (usually!) working integrated version is the foundation of how complex software is developed now. Now as our reports get more and more complicated, and different people want to collaborate around a key report and add fields, measures, new data sources etc, I've found we've hit exactly the problem that VCS solves. Unfortunately without a mergeable format (i.e. a text format that tends to keeps things that change cohesive, but separate from other changes) it's impossible to manage without VCS. However ... I've been playing with the deserialization of pbits (they're a zip file of json/xml files) starting with the excellent work that kodonnel and Vineet Naik have done here: https://github.com/awaregroup/powerbi-vcs I've now got it to a point where diffs are manageable (splitting the largest files into subfiles) useful (removing ever-changing modified times that simply aren't relevant) and mergeable (a bit more expansion into lines for multiline text, and of course repackaging back to the real pbit format). And it really works well! It's a bit hacky though ;) But it is *possible* and that's the key. If MS could tweak their template serialization format a little, we would all get a huge boost to the manageability of Power BI reports for more complex scenarios. And adding git support would then be trivial ;)