Forum Discussion

prabhatnath's avatar
prabhatnath
Advocate III
2 years ago
Solved

Connecting to Azure DevOps Online from DataFlow

Hello,   I could not find the connector for Azure DevOps Board from the Power BI Online - Dataflow where I can connect to Azure DevOps Analytics View. Is the process in the Dataflow is different th...
Need Help
prabhatnath's avatar
prabhatnath
Advocate III
2 years ago

Thanks ibarrau 

Yes, at present I have identified the oData as alternative but I am facing issues to get the relavent WorkItem Revisions, which was easy using the Analytics View. Have you every tried to get these revisions using oData, if so please gude me.

 

Thank you for your reply. Lets see if any expert here can suggest anything.

 

Thanks,

Prabhat

ibarrau's avatar
ibarrau
Super User
2 years ago

I don't remember getting the revisions for the reports I have built, but I found this on the doc: https://learn.microsoft.com/en-us/azure/devops/report/extend-analytics/odata-query-guidelines?view=azure-devops#-do-use-workitemrevisions-entity-set-to-load-all-the-revisions-for-a-given-work-item

There is an entity "workitemrevision". That might help. Example:

https://analytics.dev.azure.com/{OrganizationName}/_odata/{version}/WorkItemRevisions?
  $filter=WorkItemId eq {id}
  &$select=WorkItemId, Title

Regards