Anonymous's avatar
Anonymous
Not applicable
6 years ago
Status:
New

Dataset schedule refresh fails intermittently.

Hi Team,   I have one Power BI Dataset which is connected to the Azure Database. I have scheduled refresh for five times a day. Out of five times, it works 3 times but fails two times. If I try to ...
Gateways
Report Server
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

I have the same (or similar) situation of intermittent failures of Power BI Pro dataset refresh from an Azure SQL Database.

 

Failure details: Microsoft SQL: Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=35; handshake=24;

 

Failure details: An error happened while reading data from the provider: 'Internal .NET Framework Data Provider error 6.'

 

I reviewed the Troubleshoot refresh scenarios page, but did not see any scenarios that fit my situation.  Potentially a timeout issue.

 

I was wondering if Azure SQL Database is taking a time to "wake" when the Power BI Pro dataset refresh is triggered?  Is there a recommended timeout when refreshing from an Azure SQL Database source?

 

@ssangekar - were you able resolve your problem?

 

Thanks!

 

 

 

Completed Ideas