Forum Discussion
Solved
Help Wanted - does anyone know the correct query format to return a workitem list from VSO in JSON?
Hello: Does anyone know the correct query format – using REST API - to return a list of workitems from VSO in JSON format? Background: We are producing a PowerBI dashboard to monitor mul...
Hi Virtual_Ames,
In your scenario, you need to make sure how to call VSO rest API to return the expected results firstly. You can post a thread in Visual Studio Team Services forum.
Once you make sure the VSO rest API, then you can use web data source in Power BI desktop to get data, you can refer to this sample: Calling REST APIs and Parsing JSON made simple with Power BI.
Best Regards,
Qiuyun Yu
Virtual_Ames While this won't answer your question directly, I just wanted you to be aware that MSFT released the connector to VSTS (VSO) to the Desktop in the January release... So unless there was a different reason other than "there was no other way" to access the info, this might streamline your efforts.