Skip to main content

Power BI

New

Devops Process

Vote (69) Share
Daniel Bartley's profile image

Daniel Bartley on 27 May 2017 14:17:22

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.

Comments (6)
Daniel Bartley's profile image Profile Picture

36633c99 4627-417a-ad0d-96f18d13a791 on 05 Jul 2020 23:56:18

RE: Devops Process

Wonderful post, Thanks for sharing.

https://www.kellytechno.com/Hyderabad/Course/devops-training

Daniel Bartley's profile image Profile Picture

b9e14396 410b-438c-9731-4319f8607de5 on 05 Jul 2020 23:22:02

RE: Devops Process

Anyone knows how to interact with PowerBI via command line or API?

Daniel Bartley's profile image Profile Picture

11b85175 2ba7-4a19-afa1-f947abd988a8 on 05 Jul 2020 23:14:20

RE: Devops Process

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!

Daniel Bartley's profile image Profile Picture

4e71aaab e787-473e-89bf-f5084f9f9037 on 05 Jul 2020 23:07:21

RE: Devops Process

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

Daniel Bartley's profile image Profile Picture

344d73a2 a3f0-4f3e-ae30-570baf02a4e4 on 05 Jul 2020 22:57:07

RE: Devops Process

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.

Daniel Bartley's profile image Profile Picture

215f958a f4d9-4b38-96ea-87348afbebff on 05 Jul 2020 22:54:37

RE: Devops Process

Eduwizz online training is one of the Best Online Training Institute in Hyderabad, Bangalore.Eduwizz provide courses
Hybris , Machine Learning , AWS, Statistics for Beginners, Commvault Training,Devops, Netapps,Data Science , Internet of Things , IBM Blue-Mix , Hybris ,Angular JS , Node JS , Express JS , Business Analyst, Selenium testing with webdriver, Guidewire ,Adobe, RPA ,
TSM, EMC.