Connecting to Azure DevOps Online from DataFlow

[prabhatnath]

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 than the Power BI Desktop?

While from Power BI Desktop / Dataset I can do that as below:

Can you help me how can I connect to Azure DevOps Online from Dataflow?

Thanks,

Prabhat

[prabhatnath]

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

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=a...

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

[ibarrau]

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-devo...

I hope that helps,