Skip to content

Releases: AstralForest/Power_BI_Monitoring

Release 1.0.0

19 Jul 09:50
@MKarashchukAF MKarashchukAF
v1.0.0
ad2296b
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Release 1.0.0 Latest
Latest

Release Note for Version 1.0.0

Overview

In this release, we have introduced significant automation improvements and updates to our installation process, resulting in a more streamlined and user-friendly experience. We have also unified and enhanced our branching strategy. Below are the key highlights and main changes included in this release.

Key Highlights

Installation Automation

  • PowerShell Scripts Added: New PowerShell scripts have been developed and added to automate the installation process, reducing the required human time to approximately 5 minutes.
    • Provisioning Script: Automates the creation of Azure resources including resource groups, service principals, security groups, and more.
    • Trigger Script: Automates the process of triggering ADF pipelines, monitoring their status, and executing subsequent pipelines upon successful completion.

Branching Strategy

  • Unified Branching Strategy: Our branching strategy has been standardized and unified across the project to ensure consistency and improve collaboration among team members.

Detailed Changes

PowerShell Automation Scripts

  • Provision_PBI_Monitoring_Demo.ps1
    • Automates the creation of Azure resources.
    • Creates a service principal and assigns required roles.
    • Creates a security group and adds the service principal to it.
    • Writes configuration details (ADF instance name, resource group name, subscription ID) to a JSON file.
    • Deploys ADF using a Bicep file and configures necessary parameters.
    • Uploads a .bacpac file to Azure Storage and imports it into SQL Server.
  • Create-AppRegistration.ps1
    • Automates the creation of a service principal.
    • Assigns Microsoft Graph roles and grants admin consent.
  • Trigger_ADF_Pipeline.ps1
    • Reads configuration details from a JSON file.
    • Triggers the first ADF pipeline, monitors its status, and triggers a second pipeline upon successful completion of the first.

Bicep File Updates

  • Provisioning of SQL Database with S0 tier.
  • Creation of a Key Vault to store secrets securely.

REST API Integration

  • Utilization of Azure REST API to check pipeline run statuses and trigger pipelines.

Enhanced Installation Process

  • Significant reduction in human intervention required during installation, making the process more efficient and error-free.

Branching Strategy

  • Our new branching strategy has been designed to streamline development workflows and ensure smooth integration of changes:
    • Main Branch: Production-ready code.
    • Feature Branches: Development of new features.
    • Release Branches: Preparation for new releases.
    • Hotfix Branches: Quick fixes for production issues.

Additional Improvements

  • Detailed error handling and logging in PowerShell scripts to improve troubleshooting.
  • Modular and reusable script functions for better maintainability.
  • Configuration and deployment improvements for Azure Data Factory.

Conclusion

This release marks a significant step towards improving our automation capabilities and standardizing our development practices. We encourage all team members to familiarize themselves with the new scripts and branching strategy to fully leverage these improvements.

Thank you for your continued support and contributions.

Assets 2
Loading