CICD deployments using Fabric Items

[Anonymous]

Hello People,

I am working on requirement to integrate the Fabric workspaces to Azure repository and create the deployment pipelines for it. I went through the microsoft documentation and implemented everything and its working fine.

But as per the below link i see we can use Azure Devops Build and release pipelines to automate the CICD deployments and deploy the Power BI content automatically to Development, Test or Production workspaces accordingly.

Automate deployment pipelines with APIs for Power BI items - Microsoft Fabric | Microsoft Learn

I wanted to implement the similar solution for fabric items also i read in the link that Service Principal will support only Power BI automated deployments then does it mean that it wont support Fabric items like Data Pipelines, Warehouse, Notebook, Spark Jobs etc. 

Is there any way we can automate the fabric items along with Power BI items with azure devops pipelines generally most of them follows. Deployment pipelines feature is available in Fabric but still it is like manual thing right, am looking for solution where we push the code to Development workspace and it should be able to automatically deploy the content to higher stages or workspaces. 

Any idea how to implement this in Fabric.

Thanks in advance. Cheers 🤗🙂

[Anonymous]

@Anonymous 

so we have to use Deployment pipelines feature and use its Fabric APIs to automate the deployments right. It wont be like azure devops build or release pipelines to deploy items in fabric. and I should go with Powershell scripts for automating the process and pass pipeline names and stages as parameters and select the items.

[Anonymous · Accepted solution]

Hi @Anonymous ,

The Fabric API auto-execute deployment pipeline functionality is currently in preview and is only supported for power bi projects.

Consider the following limitations when using the Deployment Pipeline API:

     1.Data Streaming is not currently supported. Customers using data streaming can use the Power BI API.

     2.Only Power BI items support service bodies.

     3.Not all deployment options available in the Power BI API are available in the fabric. The following APIs are not    available in the Deployment Stage Content API for Fabric:

      allowPurgeData
      allowPurgeData
      allowSkipTilesWithMissing Prerequisites
If you need one of these APIs, use the Power BI APIs for deployment. However, these APIs are only available for Power BI items.

You can try this:

Sign in to Fabric using a service body or user account in the Azure DevOps release pipeline.
Use the PowerShell scripts provided in the documentation to understand the automation process.

Below is the official link will help you:

Automate deployment pipelines with APIs for Power BI items - Microsoft Fabric | Microsoft Learn

Automate deployment pipeline by using Fabric APIs - Microsoft Fabric | Microsoft Learn

Best Regards,

Xianda Tang

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