unable to connect web api

[Anonymous]

Hi,

Trying to connect a new data source(web api) in a large pbix file, but it's unable to connect and not showing any error message. Alternatively same source (web api) is connecting another pbix file promptly. Seems like something wrong in existing pbix file, but could not figure out it. Here is the web api: https://api.openweathermap.org/data/2.5/onecall?lat=55.6761&lon=12.5683&exclude=current,minutely,dai...

Any solutions!

BR

Mozammel

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Have you check if the request require authentication. For web pages that require login, the sever may return response status '401'.

There are some tutorials you could refer to:

Tutorial: Importing and analyzing data from a Web Page using Power BI Desktop

API Strategies with Power BI

how to connect my web api wtih Power BI Reports?

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.