Forum Discussion
Data Model of team services - Power BI Model
1> Yes, you're correct that you need to firstly use the REST API to get the work item historical data with Visual Studio Team Services REAT API. See: https://www.visualstudio.com/en-us/docs/integrate/api/wit/updates
2> No. They are different REST APIs. Power BI REST API is used to get dataset, dashbord and report data from PBI, while to get the work item history data you need to work with the Visual Studio Team Services REAT API.
Impactful Individual1)> No, the work item history data is unavailable in the Power BI model for Team Service because there is no specific field stores the work item history data in the Team Service cube. To get the work item history, you need to work item API to get all revisions (the API is for TFS but works for VSTS as well) and then import the data into PBI.
2> If you click the "Visual Studio Team Services" dataset in Power BI Service, you will check the details on what is included in the data model, however, you're not able to check the relationships.
Thanks for the information.
1) You meant that we need REST API to get the neccessary data into an excel file then connect that file to PowerBI for our reporting.
Is my understanding correct?
2)Also is it possible to directly use REST API with Power BI to extract data from Power BI.
- Vicky_Song
1> Yes, you're correct that you need to firstly use the REST API to get the work item historical data with Visual Studio Team Services REAT API. See: https://www.visualstudio.com/en-us/docs/integrate/api/wit/updates
2> No. They are different REST APIs. Power BI REST API is used to get dataset, dashbord and report data from PBI, while to get the work item history data you need to work with the Visual Studio Team Services REAT API.