Azure DevOps Power BI Database Replica

There is a data copy operation which runs in Azure DevOps that creates a replica of the production database that is then made available in Power BI.

The Azure DevOps Release S105 PaaS to Azure Data Copy contains the tasks required to complete the process.

Some of the tasks connect to the Azure platform using a Service Connection which authenticates using a Service Principal. The secret for this will expire periodically and therefore needs renewing. Documentation on how to manage a Service Principal is available here. Be aware that the GitHub actions also uses the same Service Principal too, so the JSON secret value will need updating at the same time in the secrets section of GitHub Actions.