How to get data from a particular Azure DevOps Board ?

[Anonymous]

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

[Hariharan_R]

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-devop...

You can take those view and build the dashboard. I dont think you can connect to the dashboard and get the data.

Thanks

Hari

[simontaylor]

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.