Automate Power BI Report content into Devops

[eng_123]

We have report with work items and tasks in Power BI and would like to copy the content and automate in regular basis to DevOps Project. Does anyone have any knowledge about on this could be achievable?

[v-jianboli-msft · Accepted solution]

Hi @eng_123 ,

You can try to use the Azure DevOps REST API to create work items in your DevOps project. You can use Power BI's REST API to extract the data from your report and then use a custom script or tool to transform and upload the data to Azure DevOps. Alternatively, you can use a third-party integration platform like Zapier or Microsoft Flow to automate the transfer of data between Power BI and Azure DevOps. These platforms offer pre-built connectors that can be configured to automatically create work items in your DevOps project based on data in your Power BI report.

Hope this could help you!

Best Regards,

Jianbo Li

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