Skip to main content
Microsoft Idea

Power BI

Needs Votes

Power BI collaborative development

Vote (1052) Share
Giuseppe Piluso's profile image

Giuseppe Piluso on 31 May 2018 16:42:48

allows multiple developers to work collaboratively on the same PBIX.

Idea could be separate back-end (advanced editor) and fron-end (modelling and report design) or allows the possibility to merge more than one pbix.

Comments (12)
Giuseppe Piluso's profile image Profile Picture

Andreu fil on 19 Apr 2024 09:40:10

RE: Power BI collaborative development

Good information, thankssehackear.top

Giuseppe Piluso's profile image Profile Picture

elias zafrani on 18 Apr 2024 23:11:04

RE: Power BI collaborative development

ThanksHackear Instagram Hackear WhatsApp Hackear Facebook

Giuseppe Piluso's profile image Profile Picture

pag on 06 Jul 2020 00:10:45

RE: Power BI collaborative development

This fix should also accommodate standard version control through git or other protocols which would improve the ability to integrate with Azure DevOps and Github for building and working collaboratively.

Giuseppe Piluso's profile image Profile Picture

Power BI User on 05 Jul 2020 23:41:38

RE: Power BI collaborative development

Also a separation of data and code: can already be done somewhat with .pbit (and you can diff a .pbit) but that is far from satisfactory and not easy to automate. Would much prefer for the Power Query M commands to be able to act server side in development (perhaps dataflow heading this way but doesn't help right now as not part of refresh).

Report design already separated from model by getting data from BI Service so that part of collaborative development not an issue for us.

Giuseppe Piluso's profile image Profile Picture

Oscar on 05 Jul 2020 23:40:15

RE: Power BI collaborative development

Being able to follow dev cycle practices like manage in source control and look at code (to compare versions, manage settings and parameters that are scattered through UI) would be a game changer. Power BI will have massive adoption once it wins over the developer community, and all it needs to do is open up the code and allow creation of internal variables, functions, to provide the developer greater ability to refactor.

Giuseppe Piluso's profile image Profile Picture

Tom on 05 Jul 2020 23:33:54

RE: Power BI collaborative development

Collaboration is the essence of team work, so far I have found Power BI to be lacking in this big time. We tried publishing to the service to collaborate but lo & behold the calculated measures do not come through and dev features are limited in the online version.

Giuseppe Piluso's profile image Profile Picture

Guido de Vries on 05 Jul 2020 23:33:28

RE: Power BI collaborative development

Power BI would be nearing perfect if it could be used in a collaborative environment. Merging, source control, version control, deployment control, everything.

These concepts have been worked out allready through Agile DevOps, and this should be integrated so that you can manage it all in one place. This should be the next step for PowerBI's journey in conquering the Microsoft BI world. Microsoft, make this happen!

Giuseppe Piluso's profile image Profile Picture

Dan Robbins on 05 Jul 2020 23:31:48

RE: Power BI collaborative development

You can already decouple the data from the visualizations. (see below)

Having the ability to DIFF PBIX files and MERGE changes would be very helpful.

1. Perform all of your Data Modeling (Power Query M and DAX) in one PBIX file.
2. Publish it to the Power BI Service.
3. Open a new Reports PBIX file, select Power BI -> Power BI datasets as your data source.

You can also add additional DAX to the Reports PBIX file.

This allows versioning of the Dataset and building Reports tailored to different audiences.

The Report PBIX files are ### KB while the Dataset PBIX files are ###,### KB or larger.

Giuseppe Piluso's profile image Profile Picture

Power BI Ideas Admin on 05 Jul 2020 23:27:59

RE: Power BI collaborative development

You can decouple your ETL (Power Query M) & Model (DAX) from the Report definition using Analysis Services Tabular. If you have an Azure AS instance, you can even deploy the ETL & Model portion of a .pbix directly to it. This may not be an option for smaller organizations, as Analysis Services is far from free, but to those who can...

The good: IT can govern the semantic model and still provide a lot of reporting flexibility to end-users.

The bad: Analysis Services models at the 1400 compat-level are still crammed into a single-file .bim file... not a good thing for your VCS.

The ugly: The Analysis Services tooling in SSDT for Visual Studio feels a bit abandoned. They ported the Power BI "Get Data" experience into SSDT a while back, which is great, but Power Query Groups are broken/unimplemented, making managing the ETL for larger projects a nightmare.

Giuseppe Piluso's profile image Profile Picture

Power BI User on 05 Jul 2020 23:26:23

RE: Power BI collaborative development

Great Idea. It should also allow us to use version control systems in order to keep up with the changes everyone has made