Speak guys !!
In this post I will share some lives I participated where we show how to version and deploy models and reports in Power BI using Azure DevOps.
This knowledge is essential today, as it brings us a series of benefits in the development cycle of data projects:
- Possibility of having different environments for development, testing and production, where the customer will actually access. This also allows data between environments to be different and masked, preventing unauthorized access and leakage of real production data (LGPD)
- Developers just need to have permission in the development environment. This increases security and compliance in the production environment, preventing inappropriate, incorrect and unapproved changes.
- Version control over every change, being able to identify when, who and what was changed, and being able to restore a correct version after a wrong change has been made
- approval control about changes submitted in each environment, allowing you to have one or more approvers before the change is published
- Change process is fully automated, avoiding manual errors that would be needed without DevOps, where the developer would have to modify the files for each environment, remembering to change the connection details and publish to the environment correctly. Any mistake due to lack of attention could cause serious problems.
- Change governance, ensuring control over everything that is done and changed, even allowing to create a "Link" between the change made with a call to facilitate the identification of what motivated this change
Spreadsheets Channel - Versioning in Power BI
In this live, held on 09/06/2022, Leandro Bernardino demonstrated how to version and deploy Models and Reports in Power BI with Azure DevOps in a very practical and intuitive way using the Power BI Deployment Pipelines and the entire flow of approvals and release pipelines in Azure DevOps.
.NET Channel – Power BI: versioning your reports with Azure DevOps
In this live, held on 11/05/2022, I demonstrate several ways to version models and reports in Power BI using GitHub, Azure DevOps, Dropbox and more. I also show you how to use git bash, how to version each object in the model using the Tabular Editor and a BAT script to automate the push of changes to the repositories and the entire flow of approvals and release pipelines in Azure DevOps.
I hope you enjoy this content and until next time!