Want to export data for PowerBI to produce Kanban metrics

Cape-Code / vsts-time-and-effort

Easily plan & track time, costs, and budgets on work items.

https://marketplace.visualstudio.com/items?itemName=capecode.cc-time-and-effort

MIT License

11 stars 3 forks source link

Want to export data for PowerBI to produce Kanban metrics #13

Open xylamic opened 6 years ago

xylamic commented 6 years ago

In terms of time entering and integration with VSTS, the extension seems to work quite well. The issue we're running into is that we want to get the data out of VSTS into PowerBI, so we can calculate Kanban metrics using the real time spent on particular items. Is there a way we can export the underlying data? (Not the simple export available in the UI today)

MikeCarlo commented 5 years ago

I also would like this feature. I am not quite sure how to access the hours and estimates columns when producing a report. Is there something I am missing so I can see hours on a Query view?

Ultimately I would like to surface the hours and estimates data in a PowerBI report.

cszmagara-tw commented 4 years ago

This has been open for 2 years. Has anyone had any luck getting data out to Power BI?