Forum Discussion
How to get data from a particular Azure DevOps Board ?
Hi all, I would like to retrieve data from one of my dashboards so that I can set up User Voice and User Story tracking to count them. Regards, Charline
Hi,
You can extract data from your DevOps analytics view - https://docs.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devops
You can take those view and build the dashboard. I dont think you can connect to the dashboard and get the data.
Thanks
Hari
The data can be pulled into DB if you want.
Step1: create a PBI report with ADO connector and load data into a dataset.
Step2: Publish the PBI report and Setup a dataset refresh.
Step3: Create a Power Automate dataflow to call PBI dataset via DAX query and then put json to ADLS Gen2 as CSV file.
Step4: Use ADF to pull CSV file into DB.
Done.