Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NewUser777
Resolver I
Resolver I

Can Azure devops pipelines be setup for PBIT templates and dataset BIM files which don't hold data ?

The goal is to deploy datasets built from Tabular editor and reports from Power BI desktop to Test and Prod environments using Azure devops pipeline and source control tool .

 

Key requirement is to remove data and use metadata of dataset and reports to deploy using any version control tool.Data refresh then has to be done after deployment in target workspaces in higher environments ( Test and Production)

 

The solution is something similar to the information here -https://thesqlpro.wordpress.com/2020/11/04/the-power-of-devops-and-deploying-power-bi-reports-to-dif...

The solution outlined here says there are limitations with it

 

Limitations

  • Some minor limitations are that we are required to use the powerbi file if we want to deploy both the model and the visuals. So, we will need to have the pbix file rather than the pbit.
  • File size can get large.
  • PHI and PII data, we will probably recommend the usage of parameters.
  • You cannot see changes side by side on DevOps, you will need to use tool like PowerBI ALM to see side by side changes.
  • Secrets – currently keeping secrets as variables in DevOps then it is better to use KeyVault and pull from there.
  • Unable to use PowerBI template files for more security with sensitive data such as PHI/PII.

 

Want some advice and opinion from the Power BI community if this can be achieved  or there are known limitations with Power BI Premium or Azure devops or Power BI files or dataset files coming from Tabular editor?

 

May be some questions have to be asked on Azure Devops forum but as there is a dependency on the objects asking here .

 

 

 

2 REPLIES 2
v-xinruzhu-msft
Community Support
Community Support

Hi @NewUser777 

You can try to use pipeline in Power BI, you can refer to the following link.

The Power BI deployment pipelines process - Power BI | Microsoft Learn

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Sorry , your recommended solution doesnt meet the requirements -(Key requirement is to remove data and use metadata of dataset and reports to deploy using any version control tool) .Data refresh then has to be done after deployment in target workspaces in higher environments ( Test and Production). Hence Azure Devops is pursued here . Azure devops depends also on the Power BI objects like BIM files dataset files from Tabular editor, PBIT powerbi template files .

Datasets ( BIM) deployments can be automated using Azure Devops see here - https://www.youtube.com/watch?v=8NHVFuvHwoI   

but how do we automate using PBIT templates and recreate PBIX files .?

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors