Refresh dataset via API vs Powerbi Desktop

[ronant]

Hello,

I'm having trouble updating a dataset.

When publishing a dataset via Powerbi Desktop, it takes only a few minutes and always works.

When doing it via the API or powerbi's website, it either times out with the error:

Timeout expired. The timeout period elapsed prior to completion of the operation.

Or:

ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (30) Error occurred while trying to execute a query: [SQLState 08S01] server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

The error is thrown randomly after the refresh is started, it can be 10 min, 1 or 2 hour after.

The SQL query takes 10-20 minutes to complete when I open the view used to do the refresh.

What is causing the failure?

Best regards

[Anonymous]

HI @ronant,

The first error message means your refresh operation failed due to processing time exceeding the timeout limit, have you configured the timeout property in your data connector and database side? (for power bi pro users the maximum timeout on power bi service is 120 minutes)

Troubleshooting refresh scenarios - Power BI | Microsoft Docs

The second error message means the remote server has closed the connection when data refreshed. I'd like to suggest you log in to the database side check corresponding settings if they block the requests.

Regards,

Xiaoxin Sheng