CI/CD for PowerBI Report Server (on-premise)

[fomoisreal]

Hi Team,

I'm trying to set-up a CI/CD pipelines (UAT/PROD) from AzureDevOps to On-prem PowerBI Report Server but not sure on how to do it. Most resources I found relates to PowerBI Server which uses Git Integration. However our business requirements is on-prem hence looking for way to do CI/CD

[Poojara_D12]

Hi @fomoisreal 

Setting up a CI/CD pipeline for on-prem Power BI Report Server (PBIRS) using Azure DevOps requires a different approach since PBIRS does not support Git integration like Power BI Service. Instead, the deployment process typically involves automating the upload of .rdl (Paginated Reports), .pbix (Power BI Reports), and .rsd (Shared Datasets) files to PBIRS using PowerShell scripts and the Report Server REST API. The recommended workflow involves storing the reports in an Azure DevOps repository, triggering a pipeline when changes are committed, and using an Agent Job with PowerShell scripts to publish reports to PBIRS. The PowerShell script can use the Invoke-RestMethod cmdlet to interact with PBIRS, ensuring reports are deployed to UAT or PROD environments based on pipeline parameters. You can also integrate variables and approvals to manage environment-specific configurations, such as data source updates. This approach enables automated, version-controlled deployments while meeting on-premises requirements. Let me know if you need a sample pipeline YAML or PowerShell script to get started!

[fomoisreal]

Yes please, I need the sample yaml to get things started. I understand we need to set-up our own pipelines but I dont see any resource to start with. A detailed guide would be handy. thank you so much

[Poojara_D12 · Accepted solution]

Hi @fomoisreal 

I have mentioned the details in the file below. Please check.

[fomoisreal]

thank you so much! appreciate the detailed guide

[Poojara_D12]

Happy to help 🙂

If possible consider subscribing my Youtube channel for basic to advance power BI and SQL related content, link given below.