Data Model of team services - Power BI Model

[asriniva33]

Hi,

1) Can some one let me know if the work item history data ( to track the work item state changes by person, date etc.) is available in the Power BI model for Team Services.  Since the link: (  https://www.visualstudio.com/en-us/docs/report/powerbi/vso-pbi-whats-available-vs )  only specifies about the current state of work items.

2) Also could some one confirm if the Power BI- Team Services model is a dimensional model or a OLAP cube? If any where can i find the structure of the respective datamodel 

[Vicky_Song]

@asriniva33,

1)> 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.

[asriniva33]

@Vicky_Song

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 · Accepted solution]

@asriniva33,

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.