Deploy Power Bi Reports using CI/CD

[nandagajula]

Hi,

I am looking for CI/CD solution to deploy Power BI reports from my Git repo. Please share if you have any solutions to achive this? Appreciate if you can provide some help here.

Thanks,

Kishore

[Anonymous]

Hi @nandagajula , @markive ,

This is my understanding as of Nov 2021.

There are serious challenges with implementing CI/CD using Power BI with the way it is architected at the moment

In my case, I have a shared dataset (PBIT) and multiple PBIX reports around the shared dataset

1. PBIT files are binary. This prevents any Pull Request review (an essential step prior to CI/CD)
2. You cannot upload a PBIT to Power BI service using the REST API . You will have to convert it to PBIX by opening the PBIT using Power BI desktop

Overall the CI/CD story is non-existent.

[markive]

One approach that might work is to create an Azure Logic App & Azure Function

Connect it to your Github repo and when there is a new commit have that trigger the Logic App to call the Azure Function. The Azure function should download the PBIX file form github and then use the PowerBI REST APIs to publish the dashboard automatically.

[markive]

See this: https://community.powerbi.com/t5/Developer/Automate-publishing-reports-process-creating-an-azureDevO...

[nandagajula]

@markiveThanks for your response. Has anyone tried and successful earlier because what i am facing issue right now is access to Power Bi service