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

[Sam02]

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

[tankepaus]

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

[mdent]

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 

[Anonymous]

Hello  @Sam02 ,

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

Thank you,

Sau