DevOps

This repository is used to demonstrate Tabular Editor integration with GitHub Actions for Power BI or Analysis Services CI/CD

Actions

The repository contains a single workflow which performs the following actions against the AdventureWorks model source code in the repo:

1. Uses a PowerShell script to Download Tabular Editor 2.x
2. Run a Best Practice Analysis
3. Run a Schema Check (i.e. checking that columns in the source SQL partitions are correctly mapped to imported column). Uses a C# script to update the data source credentials before performing the Schema Check.
4. Deploy the model to an instance of Analysis Services (that could be SSAS, Azure AS or Power BI XMLA).

Instructions

To replicate this in your own fork, you have to set up the following environment and environment variables under the GitHub repository settings:

1. An environment named "Dev"
2. One environment variable named "SQLDW_CONNECTIONSTRING". This should hold the SQLNCLI connection string to access a SQL database that holds AdventureWorksDW2019:

data source=<SQL SERVER NAME>;initial catalog=<SQL DATABASE NAME>;persist security info=True;user id=<SQL USERNAME>;password=<SQL PASSWORD>

3. One environment variable named "AS_CONNECTIONSTRING" which points to the Analysis Services or Power BI workspace where you want the workflow to deploy the model.

Provider=MSOLAP;Data Source=<AS SERVER NAME>;User ID=<USERNAME>;Password=<PASSWORD>

To use a Service Principal, specify the following:

Provider=MSOLAP;Data Source=<AS SERVER NAME>;User ID=app:<APPLICATION ID>@<TENANT ID>;Password=>APPLICATION SECRET>

Executing the workflow

The workflow has a workflow_dispatch event trigger, so it will have to be triggered manually from the GitHub "Actions" tab. If set up correctly, the output of the workflow should look like this, indicating succesful execution of all steps: