Connecting data source through Power BI API (ADO API)

[durgaraop21]

Can you please help me,

I am trying to read the data from ADO using Power BI API, But i am facing issue after connection established its look like i dont have access to the data. 

please find the below screenshot for your reference
When i was connection to ADO API, I did't see tha actual data i was see only the HTML code
Which was in the below screenshot:

Finally i was trying to login with my credentials but i was unable to login and getting below error

[Anonymous]

Hi @durgaraop21 

It seems that the url you provided for the Web connector is not an API but a web page, so it uses Web.Page or Web.BrowserContents function to return the HTML for the specific url. With these functions, it would try to get a table between <table></table> tags from the HTML codes, which led to the failure. 

You may try using "From OData Feed" instead of "From Web". For more information, please read Access Analytics data through Excel - Azure DevOps | Microsoft Learn

Hope this would be helpful. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!