There is currently no clear, built-in system for source control, test, gated approval and release of new reports.
If you have admin rights, you have god mode. Use it with caution.
As a result, IMHE analysts teams are likely to learn the hard way about all the reasons why formal IT teams have developed governance controls for software development and release.
I can imagine this becoming a functionality of Power BI Premium since it's an enterprise type feature.
I can imagine a scenario where the reports authors publish to a project in VSTS . Then VSTS' build environment runs unit tests and continuously deploys to the power bi service just as it would to the Azure App service or a Sql database.
Analysts should benefit from the mistakes of generations of developers and be encouraged to follow best practice.
Wonderful post, Thanks for sharing.
Anyone knows how to interact with PowerBI via command line or API?
Matthias Jakob commented
Completely agree. This is actually the reason why we are currently discussing not to keep on using Power BI in our environment and look elsewhere for productive use.
Automated deployment, with adapting connectionstrings in an external config file is a base requirement for agile dev and devops!
Eugene Niemand commented
Is there any guidance on the devops/ci process. I find it highly frustrating to develop against a local SSAS Tabular instance.
Here is my process:
Author my report on PowerBI desktop
Make some changes in SSAS
Change/refresh report to validate
Iterate above (all good up to this point)
Now I deploy the SSAS changes to higher environments CI/CD
If I want to publish the report I need to edit the connection in PowerBI desktop and republish for every environment. We need a way to change connection strings or paramterise them somehow
I couldn't agree more! This is especially needed in bi-modal or IT-centric scenarios where an investment in a formal CI/CD process is already in place for the data warehouse.
<a href="http://www.eduwizzonlinetrainings.com">Eduwizz online training</a> is one of the Best Online Training Institute in Hyderabad, Bangalore.Eduwizz provide courses <a href="http://www.eduwizzonlinetrainings.com/hybris-development-online-training.html">
Hybris </a>, <a href="http://www.eduwizzonlinetrainings.com/machine-learning-online-training.html">Machine Learning </a>, AWS, Statistics for Beginners, <a href="http://www.eduwizzonlinetrainings.com/commvault-online-training.html">Commvault Training</a>,Devops, Netapps,<a href="http://www.eduwizzonlinetrainings.com/data-science-online-training.html">Data Science </a>, Internet of Things , IBM Blue-Mix , Hybris ,Angular JS , Node JS , Express JS , Business Analyst, <ahref="http://www.eduwizzonlinetrainings.com/selenium-testing-with-webdriver-online-training.html">Selenium testing with webdriver</a>, <a href="http://www.eduwizzonlinetrainings.com">Guidewire</a> ,<ahref="http://www.eduwizzonlinetrainings.com">Adobe</a>, <a href="http://www.eduwizzonlinetrainings.com">RPA </a>,
<a href="http://www.eduwizzonlinetrainings.com">TSM</a>, <a href="http://www.eduwizzonlinetrainings.com">EMC</a>.