PowerBI.com should have some type of Source Code control integration for change control
We keep the pbix files in Bitbucket, but it's impossible to see what had changed with it being a binary file. We have to keep manual records for release info. One of the main reasons for Source Control is to have visibility of what changed, it's no longer just about keeping the previous version(s) if something goes wrong.
I would love to open within Visual Studio and have GIT or TFS as version control
Jeff Messer commented
A team experienced with SSRS and SSDT in Visual Studio will continue to have difficulties adopting Power BI (and especially Power BI Report Server) without some support for standard source control practices. At the very least we need a Visual Studio plug-in that either integrates Power BI Desktop components into Visual Studio, or one that connects Visual Studio more tightly with Power BI Desktop. Even if we can't diff the files, at least making the templates and frameworks for PBI reports behave more like SSRS reports would help. Or...finish integrating paginated reporting within Power BI Desktop and expand the toolsets from there.
Steve Jones commented
Please ensure that the for mat allows for text diffs. I might also ask that code be separated from visual items in the format so that I can easy see different calculation changes. Very important for auditing of financial reports.
Srinivas Kalva commented
Can we integrate Power Bi with BitBucket
This should also work for PowerBi for Reporting Services
Isn't this already in DevOps https://msftplayground.com/2018/12/administrating-and-publishing-power-bi-resources-via-azure-devops/
Mary Garcia Charumilind commented
There's a potential solution in this idea too https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36978934-built-in-git-support-in-powerbi-desktop
this is basic need for professional development work
Charlie Blake commented
If Microsoft made PowerBI Template (.pbit) files more flexible, i.e.:
1) capability to export a .pbit from PowerBI Report Server (and cloud)
2) OR capability to export a .pbit by command line from a .pbix, preferably PowerShell so it does not depend on the PowerBI Desktop .exe
3) capability to upload a .pbit to PowerBI Report Server (and cloud)
then some of the deployment automation could be completed by the community which has done of some this work already
Git-LFS has been an interesting solution as well, but I think is ultimately just a crutch for the main problem here in that the file format is inflexible
Stephen Wichman commented
adding my voice to the chorus. Really looking forward to this
Still waiting... a text friendly format is really needed. Not only for source control but for editing too; no one likes going through a cumbersome UI to make repetitive changes or setting up repetitive relations, filters, and settings changes for every control...
Russell Freeman commented
I need this too. I use BeyondCompare for diffs, so for me the solution is ideally just the ability to point PowerBI at a folder with the same folder structure as the zip file. You could then just version control the folder. That should be a small enhancement as it is just the ability to either OpenFile(filepath) or OpenFolder(folderpath)
I can't understand why this can not be done yet. In the end pbix file is a zipped version of folders, xml and text files. As a work around, we have been using beyond compare on unzipped pbix files to compare. But we can't do much more.
an in built compare mechanism with DevOps/Git and/or Visual Studio would be very much welcome.
Total showstopper. Even if MS has got the opinion, that Power BI is not a developer tool, source control is essential for continuous development. I understand that there is mainly a problem of the way pbix files are stored, as there is no xml structure so that diffs are not doable for now. But still: commenting the changes someone did is absolutely essential!
Christopher Mank commented
+ 1 on the integration here with Git and Azure DevOps.
Artur Correia commented
+1 ... How can we deliver an enterprise PowerBI project without source control? I need to integrate all PowerBI Reports as part of Azure DevOps / Visual Studio project.
Matthew Turner commented
I'd like to see at least the DAX queries stored in a way that can be source controlled, perhaps an option to store them in separate files that can be loaded into the pbix file?
Anahita Z. commented
Dear Power BI team, this is badly needed …
Thomas Jespersen commented
OMG Microsoft! This gotta be one of most commented Idea I've seen on your idea forums. And you don't even respond.