Forum Discussion
Fabric Warehouse component Deployment using Azure Repo(DevOps)
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.
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
4 Replies
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
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
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
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