Azure DevOps Services API

[Anonymous]

I am hoping that someone can help me with the issue that I am experiencing.  

 I am trying to build a report that will show the count of how many projects we have across all of our Azure DevOps Services (ADS) Organizations. The report should also show the count for the projects that actually have a Build associated to it. 

 To accomplish this, I am calling the appropriate ADS APIs and for the most part, it is working. However, i am having an issue retrieving the build results for some projects. For example, I call the following and retrieve the count of Builds the projects has   

= Json.Document(Web.Contents("https://dev.azure.com/" & orgName & "/" & projectName & "/_apis/build/builds?api-version=5.0"))

Then I call the next project in the org and I receive using the same syntax and receive:

I can copy and paste the URL from the Json.Document syntax above (of course putting the proper org and project name), and I get results back using a browser or Postman. Therefore, I am puzzled at why it is not working.

I am hoping that someone can tell me where - if possible - I can see why the error message is happening. Perhaps a log file or how I can see the actual json that is being returned to determine if it is truly an invalid json file.

Thank you in advance. 

Julio

[v-juanli-msft]

Best Regards
Maggie

[Anonymous · Accepted solution]

This issue was due to the connection. Even though I am stating Json.Document, the content being returned was Web.Page. I deleted the connection and recreated it and now everything is reporting correctly.

[Anonymous]

If you could help me with problem related to accessing Azure DevOps analytics services using ODataFeed data source.

I posted on this link : 

Kindly help: @Anonymous @v-juanli-msft 

https://community.powerbi.com/t5/Desktop/Using-OData-Feed-Azure-DevOps-Analytics-URL-working-in-browser/m-p/891228