Version Control, Automated Deployments, and Shared Data Sets

[KenvM]

Hello,

We've got a few questions about how best to work with Power BI. I'm hoping someone can provide some insight, or possibly direct us to a roadmap that will help answer where Microsoft is going with Power BI.

1. What is the recommended approach to source control? Our developers use git, but I'm not sure I want to introduce that to our power users. I've found some articles (example: http://www.desertislesql.com/wordpress1/?p=1482) that reference using Sharepoint/One Drive, but it seems that doesn't work with App Workspaces anymore?

1. It looks like the only option for automated deployment is using UIAutomation.dll (or something similar) to refresh the .pbix (or, alternatively a .pbit) and then publish it to Power BI - either using the desktop client to publish or the API. Are there plans or a timeline for improving this?

1. We create Data Sets in .pbix files and then connect to them as a Power BI Service. However, this doesn't appear to work across App Workspaces. This means we either need to track which workspace the file is deployed to, or have multiple copies of the file. Is there a better approach to this?

Thanks,

Ken

[Eric_Zhang]

---

@KenvM wrote:

Hello,

We've got a few questions about how best to work with Power BI. I'm hoping someone can provide some insight, or possibly direct us to a roadmap that will help answer where Microsoft is going with Power BI.

1. What is the recommended approach to source control? Our developers use git, but I'm not sure I want to introduce that to our power users. I've found some articles (example: http://www.desertislesql.com/wordpress1/?p=1482) that reference using Sharepoint/One Drive, but it seems that doesn't work with App Workspaces anymore?

1. It looks like the only option for automated deployment is using UIAutomation.dll (or something similar) to refresh the .pbix (or, alternatively a .pbit) and then publish it to Power BI - either using the desktop client to publish or the API. Are there plans or a timeline for improving this?

1. We create Data Sets in .pbix files and then connect to them as a Power BI Service. However, this doesn't appear to work across App Workspaces. This means we either need to track which workspace the file is deployed to, or have multiple copies of the file. Is there a better approach to this?

Thanks,

Ken

---

@KenvM

• At this moment, there's no offical support for version control, some in this forum use Visual Studio to do ther version control. You can check this idea Dataset/Report Version Control and vote it up.
• What improvement do you expect? You can develop your own UI with the API Create Import if you don't like Power BI Desktop.
• What is your senario while you hope the reports cross workspaces? You can pin live page to a dashboard and then share the dashboards to those who're not in that workspace. Or you may apply Row Level Security if security is the main concern for using multiple workspaces.