topic Using Power BI Template to Automate Azure DevOps Pipelines. POWER BI CICD in Developer

Using Power BI Template to Automate Azure DevOps Pipelines. POWER BI CICD

Anonymous — Mon, 16 Mar 2020 14:49:39 GMT

Hello Power BI Experts,

I was wondering if we can integrate Power BI template with Azure DevOps Pipeline to automate publishing to worksapces. I am storing .PBIT files on Azure Dev Ops and trying to automate publishing to Worksapces using PowerShell scripts. I was able to automate these task if I have .PBIX files but was not able to do it it I have .PBIT files. Were any of you able to store .PBIT files on repo and automatically publish these files from Azure repo to the workspaces? Any help would be appriciated.

TIA

Re: Using Power BI Template to Automate Azure DevOps Pipelines. POWER BI CICD

tankepaus — Tue, 14 Apr 2020 09:14:08 GMT

I found that simply renaming the template .pbit file to .pbix was enough to get it working.

Re: Using Power BI Template to Automate Azure DevOps Pipelines. POWER BI CICD

mdent — Wed, 11 Nov 2020 00:48:32 GMT

When this is changed to a pbix, I assume this is deployed via powershell scripts. I have been trying to deploy a pbit with tabular editor so the partitions remain in tack and any then dynamically refresh the specific partitions that are out of sync based on the info warnings from tabular editor. However what I am finding is the data source connections are lost due to them turning into a dynamic data source. Has anyone managed to deploy in this fashion successfully. Ideally I would like to maintain a valid pbi file type instead of converting to a model bim or database JSON

Re: Using Power BI Template to Automate Azure DevOps Pipelines. POWER BI CICD

Anonymous — Tue, 02 Mar 2021 12:56:04 GMT

Hello @Anonymous ,

What was your finaly solution? Were you able to publish a PBIT from Devops? How are you setting the datasource credentials?

Thank you,