API through web connection

[sraj]

Hi there,

This is my first time dealing with web api, I have the url with the username and password.  I am logging in with web in my get data and entered the username/password in the basic option but still when I get to the navigator I am seeing the html code and displayed text.  Can someone please advise on how I can pass that to see the data I want from this url?  

Any help is appreciated, thanks for taking your time and responding.

[lbendlin]

You are supposed to use Web.Contents  (not Web.BrowserContents)  to consume the API response.

Web.Contents - PowerQuery M | Microsoft Learn

[sraj]

Hi there - this is my first time doing this, is there any video or article that would go more in detail on this please?

[lbendlin]

power bi web.contents api data at DuckDuckGo