topic Re: Power BI REST API returns 500 response intermittently in Developer

Power BI REST API returns 500 response intermittently

yashwanthkalva — Thu, 07 Apr 2022 13:19:40 GMT

We are using the Azure Power BI REST API to get the details of various BI assets.

e.g. Listing workspaces.

The API returns 500 response intermittently,

HttpResponseProxy{HTTP/1.1 500 Internal Server Error [Content-Length: 36, Content-Type: application/json; charset=utf-8, Date: Tue, 05 Apr 2022 13:07:33 GMT] ResponseEntityProxy{[Content-Type: application/json; charset=utf-8,Content-Length: 36,Chunked: false]}}

However, on retry it continues to work as expected.

We observed this issue intermittently while invoking the list workspaces API.

/admin/groups?$top=%s&$skip=%s

The 500 response from the Power BI API is quite generic and does not have more information on the cause.

Re: Power BI REST API returns 500 response intermittently

AmosHersch — Thu, 07 Apr 2022 14:22:42 GMT

Hi @yashwanthkalva ,

You can try adding to the request URL preferClientRouting=true

In certain cases it can solve errors like the ones you desctribe, and it's not supposed to have any negative effect.

Re: Power BI REST API returns 500 response intermittently

yashwanthkalva — Thu, 07 Apr 2022 15:45:04 GMT

@AmosHersch Thank you for the response but we would like to know what does it change or mean ?

Re: Power BI REST API returns 500 response intermittently

yashwanthkalva — Fri, 08 Apr 2022 05:21:09 GMT

@AmosHersch/ MS Power BI team, please let me know if it is query param or header param, as it is returning 403 forbidden response while using as query param.