Forum Discussion
Connecting to Azure DevOps Online from DataFlow
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, TitleRegards
Hi, dataflows gen1, gen2 and Power Bi desktop don't have the same connectors. You can try doing it at desktop and copy paste the code in a blank query at dataflows. However, it could fail.
As an alternative, I do remember connecting to DevOps using ODatafeed before the connector even exist. You can check this doc to guide you on the connection and process: https://learn.microsoft.com/en-us/azure/devops/report/powerbi/odataquery-connect?view=azure-devops
You can also find some posts online showing that like: https://vinijmoura.medium.com/how-to-creating-a-report-in-power-bi-using-odata-to-connect-azure-devops-6090549f5f23
I hope that helps,