Problem with rest api connection

[Omikai]

Hi 

I have problem connecting to a rest api data source with authentication.

Im doing the same in Excel and everything works fine but when Im trying to do the same in power bi I get an error "We were not able to retriece the contents of the web page" and then Im stuck in the loading in the navigator and dont see any data.

Any clues why this is happening?

Regards Mathias

[Anonymous · Accepted solution]

Hi @Omikai ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide me with more details about your problem to help us clarify your scenario.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @Omikai ,

Please refer to the official docuement to see more details:

Use the URL parts section of the dialog to assemble the URL you want to use to get data. The first part of the URL in the URL parts section most likely would consist of the scheme, authority, and path of the URI (for example, http://contoso.com/products/). The second text box could include any queries or fragments that you would use to filter the information provided to the web site. If you need to add more than one part, select Add part to add another URL fragment text box. As you enter each part of the URL, the complete URL that will be used when you select OK is displayed in the URL preview box.

Depending on how long the POST request takes to process data, you may need to prolong the time the request continues to stay connected to the web site. The default timeout for both POST and GET is 100 seconds. If this timeout is too short, you can use the optional Command timeout in minutes to extend the number of minutes you stay connected.

You can also add specific request headers to the POST you send to the web site using the optional HTTP request header parameters drop-down box. 

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