Web.Contents Internal Server Error

[PeterH1970]

I am trying to connect to an API through the Web connector. The connection is working, but when I try to refresh I do get an error

'Web.Contents kan de inhoud niet ophalen van 'xxxxxxxxxx' (500): Internal Server Error.

When I try the URL in a browser the data is shown, so the URL is working, also in the Power Query editor the data is shown.

So why do I get this error?

[v-xicai]

Hi @PeterH1970 ,

Could you please tell us which data source would you like to connect to?

There are some similar cases about SharePoint folder data source you may refer to :

https://community.powerbi.com/t5/Desktop/DataSource-Error-Web-Contents-failed-to-get-data-from-500/t... ,

https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-get-data-from-share-point-folder/td-p/....

Best Regards,

Amy

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

[PeterH1970]

Hi v-xicai,

I am using the Web data source and just filling in the url of the REST API. As I mentioned this URL is working in a browser, and also when I created the data source, but with refreshing I got the error.

Peter

[PeterH1970]

Anyone a solution for this?