topic Re: Deploy Power Bi Reports using CI/CD in Developer

Deploy Power Bi Reports using CI/CD

Anonymous — Fri, 17 May 2019 21:53:58 GMT

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

Re: Deploy Power Bi Reports using CI/CD

markive — Sat, 18 May 2019 12:26:55 GMT

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.

Re: Deploy Power Bi Reports using CI/CD

markive — Sat, 18 May 2019 12:29:09 GMT

See this: https://community.powerbi.com/t5/Developer/Automate-publishing-reports-process-creating-an-azureDevOps/m-p/682851/highlight/true#M19298

Re: Deploy Power Bi Reports using CI/CD

Anonymous — Thu, 30 May 2019 21:54:32 GMT

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

Re: Deploy Power Bi Reports using CI/CD

Anonymous — Tue, 30 Nov 2021 12:15:18 GMT

Hi @Anonymous , @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

PBIT files are binary. This prevents any Pull Request review (an essential step prior to CI/CD)
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.