Fabric Warehouse component Deployment using Azure Repo(DevOps)

[marvelbites06]

I am working on  project for deployment of Warehouse from Fabric worksapce. I also want version control so I am using Azure Repo. I have setup the Azure Repo to deploy all the committed changes but I need to setup the Deployment pipeline in such a way that I should be able to select single table from Warehouse and deploy it to next brach(Test or Prod). I am currently working on YAML code to create the same feature but I am stuck and there was another way suggest by Copilot using Azure Pipelines but still stuck there as well. It will be helpful if anyone can help on this. Power BI deployment Pipelines Deploy entire warehouse irrespecitve of weather it completed or not which can cause issue with the prod tables. This is first time I am doing so it will be helpful.

@suparnababu8 

[v-prasare]

@marvelbites06,

As we haven’t heard back from you, we wanted to kindly follow up to check if there is any progress on above ask. let me know if you still need any further help here.

Thanks,

Prashanth Are

MS Fabric community support

[v-prasare]

@marvelbites06,

As we haven’t heard back from you, we wanted to kindly follow up to check if there is any progress on above ask. let me know if you still need any further help here.

Thanks,

Prashanth Are

MS Fabric community support

[v-prasare]

@marvelbites06,

As we haven’t heard back from you, we wanted to kindly follow up to check if there is any progress on above mentioned issue. let me know if you still need any further help here.

Thanks,

Prashanth Are

MS Fabric community support

[v-prasare · Accepted solution]

Hi @marvelbites06, attaching same thread posted earlier for visibility here.

Solved: Fabric Warehouse component Deployment using Azure ... - Microsoft Fabric Community

use download sql project option to download whole project. then checkin this to devops branch, then deploy it to the destination worspace.

 

Store each table as a separate .sql file in your Azure Repo (e.g., tables/dimCustomer.sql).

Create a YAML pipeline/powershell script to pick the required folders

Run the CI CD pipeline manually for deployment

Please refer to below documentation related to deployments:

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

Deployment Pipelines - Create Deployment Pipeline - REST API (Core) | Microsoft Learn

Thanks,

Prashanth Are

MS Fabric community support