DataSource.Error : Web.Contents failed to get contents from « https://XXXXXXXXX » (500)

[Anonymous]

Hi,

I get data from an API through a connector. 

It works well except for some inputs which return the following error : 

DataSource.Error : Web.Contents failed to get contents from « https://XXXXXXXXX » (500) : Internal Server Error

I know that these inputs do have data to be returned (those who don't have data still return an empty table). 

Do you have any advice on how to solve this ? 

Thanks in advance. 

[v-chenwuz-msft]

Hi @Anonymous,

I suggest that you first test the availability of the API directly using one of the other tools. For example, postman. Make sure the headers information is correct. It may be that some of your headers are missing, such as connect-type or User-Agent.

500 statu code is mostly the server encountered an unexpected condition that prevented it from fulfilling the request.

500 Internal Server Error - HTTP | MDN (mozilla.org)

Best Regards

Community Support Team _ chenwu zhu

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

[amitchandak · Accepted solution]

@Anonymous , refer if old solutions can helo

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

https://community.powerbi.com/t5/Desktop/DataSource-Error-Web-Contents-failed-to-get-contents-from-app/m-p/2417545

https://community.powerbi.com/t5/Power-Query/DataSource-Error-Web-Contents-failed-to-get-contents-from-URL/m-p/2181574