REST API PostRows - random 'Internal Server Error'

[ananchev]

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

[Anonymous]

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