Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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 .
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 .?