Skip to main content

Power BI

Needs Votes

source control

Vote (869) Share
Michael Steineke's profile image

Michael Steineke on 09 Sep 2015 03:46:32

PowerBI.com should have some type of Source Code control integration for change control

Comments (66)
Michael Steineke's profile image Profile Picture

9ae2f321 beeb-4a16-95da-7f05c3a7079e on 06 Jul 2020 00:15:34

RE: source 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.

Michael Steineke's profile image Profile Picture

e6d3428a 82cf-4f9b-b58d-bc53968edfbc on 05 Jul 2020 23:55:40

RE: source control

I would love to open within Visual Studio and have GIT or TFS as version control

Michael Steineke's profile image Profile Picture

ea5ae7f9 2efe-450c-8032-6e00196e6c1b on 05 Jul 2020 23:54:23

RE: source control

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.

Michael Steineke's profile image Profile Picture

3e0209fe 0328-48d5-8e3c-e982d49f53b3 on 05 Jul 2020 23:51:39

RE: source control

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.

Michael Steineke's profile image Profile Picture

e6b8bc80 f5e4-4646-8004-8b8af0589d52 on 05 Jul 2020 23:51:39

RE: source control

Can we integrate Power Bi with BitBucket

Michael Steineke's profile image Profile Picture

baf430fd 9745-42c6-93a5-adfdcabcd071 on 05 Jul 2020 23:51:15

RE: source control

This should also work for PowerBi for Reporting Services

Michael Steineke's profile image Profile Picture

a32e1680 86cf-4e2a-b9fb-88041d8e7b5e on 05 Jul 2020 23:49:28

RE: source control

Isn't this already in DevOps https://msftplayground.com/2018/12/administrating-and-publishing-power-bi-resources-via-azure-devops/

Michael Steineke's profile image Profile Picture

20193663 8918-4ef8-917f-2f5e50cd0a55 on 05 Jul 2020 23:42:18

RE: source control

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

Michael Steineke's profile image Profile Picture

48182736 71bf-4569-a616-5d54cc0b7591 on 05 Jul 2020 23:41:22

RE: source control

this is basic need for professional development work

Michael Steineke's profile image Profile Picture

c7e652e6 9482-4d6f-9375-5e0f5bb18a63 on 05 Jul 2020 23:40:38

RE: source control

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