Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to load Azure Devops Boards data in Power BI?

I have been trying to load Board Column data from Azure Devops into Power BI but I am getting the following error when trying to expand the BoardsLocation field: DataSource.Error: OData: Reques...
Dataflow
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
3 years ago

Hi Anonymous,

 

It seems like the error is related to the query specified in the URI not being valid. The Analytics Service doesn't support key or property navigation like WorkItems(Id) or WorkItem(Id)/AssignedTo, which might be the reason why the BoardsLocation field is not expanding correctly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Sahir,

    Thank you for your replies. 

    I think the API route will be very difficult to maintian and develop because I am trying to get historical work item revisions of the board columns for a huge amount of data. The API docs show that each API call retrieves the WorkItemRevisions of one WorkItem at a time. 

    Why is it that the data can be located in WorkItemRevisions (BoardLocations column), but it cannot be expanded? What is resulting in the N + 1 problem? I have even tried to expand the BoardLocations column for one WorkItem at a time and it still results in the same error.