Skip to main content

Power BI

Needs Votes

Dataset/Report Version Control

Vote (521) Share
James Snowball's profile image

James Snowball on 07 May 2015 18:53:31

Currently, I can upload an Excel file with Power View reports and the data behind it. This is great, but the file cannot have any version control.

I would need to be able to continue developing my reports through version control and then point Power BI to the updated dataset/report without having to re-upload and create everything from scratch.

This becomes absolutely essential when you consider dev/production environments. We can't expect to provide users with cool new dashboards, then a week later take it down because there is a newer version.

Comments (40)
James Snowball's profile image Profile Picture

Neil Palmer on 05 Jul 2020 22:33:26

RE: Dataset/Report Version Control

It would be great to see Microsoft publish a recommended workflow for this.

Like many others, we are currently holding our PBIX files in git as binary files. This gets us close, however there is no way to source control dashboards.

James Snowball's profile image Profile Picture

Steve on 05 Jul 2020 22:32:37

RE: Dataset/Report Version Control

I typically increment version numbers in filenames as I develop on PBI desktop. If I upload my latest report to PBI online, then I have to remove all the existing sheets from my dashboard and pin all the sheets I want from the new report. Would be good if you could point a dashboard at a newer report and pick up all the sheets with the same name.

James Snowball's profile image Profile Picture

Dieter Van Wassenhove on 05 Jul 2020 22:27:16

RE: Dataset/Report Version Control

We need to be able to manage having multiple dev's work on a report together and allow merging versions to combine those changes. Right now all work has to be serialized through a single person that has the golden pbix or pbit file. It would help a lot if the template was exposed as text so that we can manage merging changes and using source control.

James Snowball's profile image Profile Picture

Tracy on 05 Jul 2020 22:25:30

RE: Dataset/Report Version Control

I posted a question about deleting pending changes and it was suggested that I post to this thread. Below is my post:
"I've been looking for a way to not apply the pending changes, but haven't had any luck. Is there an option or way to do this?

Any help would be greatly appreciated."



James Snowball's profile image Profile Picture

Melissa Coates on 05 Jul 2020 22:25:30

RE: Dataset/Report Version Control

'@Tracy - As you've discovered, changes to reports & dashboards in workspaces are visible immediately. I believe there's basically 2 ways to have more control: (1) One way is thru use of organizational content packs because you choose when to publish new changes (and users have to accept those changes when notified...sidenote: organizational content packs also allow users to personalize their own copy so that's a user training issue because people easily get confused which is the original & which is their personalized version). (2) Make your changes in Power BI Desktop rather than in the service at PowerBI.com. That way you control when the changes are deployed & visible to others. This is more about having a process around where changes are made (because of course there's no way to prevent changes in the service). Good luck with it.

James Snowball's profile image Profile Picture

Julio Gonzalez Melendez on 05 Jul 2020 22:19:53

RE: Dataset/Report Version Control

Having version control is essential especially when dealing with a content pack. I agree that being able to tell one version from the other would be of great value to our team. If the report, dashboard or dataset contains the same name, the version number can appear in parenthesis so that users can tell one from the other. Also, if users had the ability to rename the dataset so that the same dataset doesn't appear in duplicate or triplicate would be a great highlight.

James Snowball's profile image Profile Picture

Power BI User on 05 Jul 2020 22:18:10

RE: Dataset/Report Version Control

This is a very important feature to position Power BI as a full fledged reporting tool for end users. Else, there would be serious challenge for supporting Power BI reports

James Snowball's profile image Profile Picture

Pedro Innecco on 05 Jul 2020 22:16:56

RE: Dataset/Report Version Control

Version control is a must for PowerBI. Some basic version control in the free version, an perhaps some advanced version control in the Pro (perhaps via SharePoint online document libraries? just splitballing here)

James Snowball's profile image Profile Picture

amien on 05 Jul 2020 22:10:49

RE: Dataset/Report Version Control

'+3 vote for me

James Snowball's profile image Profile Picture

Suman Bhagavathula on 05 Jul 2020 22:02:39

RE: Dataset/Report Version Control

Yes, this is a very important feature for us. Right now we have to redo a lot of things if we just want to modify one thing on an existing Report.

Merged Idea (2)