Power BI REST API returns 500 response intermittently

[yashwanthkalva]

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. 

[yashwanthkalva]

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

[AmosHersch]

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.

[yashwanthkalva]

@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.