How to pull data into Power BI from an Azure Dev Ops extension (Time & Effort)

[pobilearner]

I am able to create a connection with Azure DevOps and can access Analytics View as well. We are using 'Time and Effort' extension in our project to track time spent on a work item and I would like to pull that data as well into Power BI which I am unable to right now. Can anyone help me if/how that can be accomplished?

[Dave_Petrie]

Have you found anything about getting the data out?

Time&Effort is gone now so i have swapped to Time Log Summary.

I still need to create a csv which is then readin by power bi - but i would prefer to get the data directly during each of the scheduled refreshes.

[v-diye-msft]

Hi @pobilearner 

You might consider voting below related idea to bring the solution coming soon:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/36271612-add-sprint-meta-data-to-...

[pobilearner]

Thanks but yours is adding more fields to the metadata whereas mine is related to the data getting pulled from an extension which is being used in Azure Dev Ops.