Power BI report using Azure DevOps as data source stopped functioning

[BernardV]

A couple of month ago I created a Power BI report using our company Azure DevOps build pipeline as data source (using odata v3.0-preview). Things were working quite well until a month or so ago it start failing to refresh the report data, and it would seem that certain values are nog longer retrievable? 

My Azure Devops OData calls attempt to retrieve the following three pieces of informtion: BuildPipelines, Builds and TestRuns (these were all working correctly). Here are some examples of how each call was created:

• https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/BuildPipelines?$filter=...
• https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/Builds?$filter=ProjectS...
• https://analytics.dev.azure.com/{organization}/{project}/_odata/v3.0-preview/TestRuns?$filter=Projec...

The above calls break, in browser, through Power BI desktop and Power BI online.

Any assistance regarding this would be greatly appreciated.

Here is an example of my the report I created using the above data source:

[BernardV · Accepted solution]

I have been assited on Stack Overflow. https://stackoverflow.com/questions/60206820/power-bi-report-using-azure-devops-as-data-source-stopp...

[artemus]

You could try using DevOps connector instead?

E.g.

= VSTS.Contents("https://dev.azure.com/{organization}/{project}/_apis/build/definitions/BuildSK?api-version=5.1")

  Note the APIs are quite a bit different though.