REST API PostRows - random 'Internal Server Error'

ananchev — Fri, 23 Apr 2021 22:45:39 GMT

I am using a Python code to execute once per day data load into a Power BI dataset using PostRows. Around 150 to 200 calls are executed sequentially with different json payloads (normally 50-60 data rows each) posting the data into few different tables within the dataset.

Randomly I get 500 - Internal Server Error response, which after retrying the request normally executes succesfully. It is rather undeterministic unfortunately.

Has anyone had such issue and what would be the best approach to tackle?

I am thinking for implementing retry logic at first place, but maybe also certain timeouts (e.g. 1s) between each call. Any advice would be welcome.

Thanks,

Anton

Re: REST API PostRows - random 'Internal Server Error'

Anonymous — Mon, 26 Apr 2021 06:57:51 GMT

Hi ananchev,

I'd like to suggest you take a look at the following document about REST API limitations if it helps:

Power BI REST API limitations

Regards,
Xiaoxin Sheng

topic REST API PostRows - random 'Internal Server Error' in Developer

REST API PostRows - random 'Internal Server Error'

Re: REST API PostRows - random 'Internal Server Error'