Issue with importing the API data

[Cheth]

I want to extract data from API using web option(Get Data), which requires an authentication by Username / Password. Once after entering the URL, PBI shows the following popup and data doesn't get loaded.



Also when we tried to access the API from a browser, we are getting the data as expected(Json format), but not when we try to import using PowerBI.
It would be helpful if anyone can guide us with solution on this.

Thanks In Advance.

[v-easonf-msft · Accepted solution]

Hi, @Cheth 

Please check the code in query editor. Does the Web connector (currently available in Power BI Desktop) automatically creates a Web.BrowserContents query?

As the error message states, the new Web connector can't be used to connect to a source that requires non-anonymous authentication. This limitation applies to the Web.BrowserContents function, regardless of the host environment.  

For more information, please refer to this official document.

Troubleshooting the Web connector 

Currently, you can't turn off the use of Web.BrowserContents in Power BI Desktop optimized for Power BI Report Server.  You need manually use Web.Page to replace Web.BrowserContents.

Best Regards,
Community Support Team _ Eason