cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MMÜ
Frequent Visitor

Azure SQL DB sporadic failures

Hi everyone,

 

we have a SQL database in Azure which is the source for most of our reports. For some days now, we witness problems with the scheduled refresh in Power BI service. They are running forever. 

 

When we try to refresh the data in power bi desktop, we get the following error:

[DataSource.Error] Microsoft SQL: 
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
(provider: TCP Provider, error: 0 - The specified network name is no longer available.).

However, if we try it immidiatley again in Power BI Desktop, everything works like a charm and the refresh in the Power BI Service will also succeed.

 

Do you have any idea what could cause this?

 

Best regards

Mathias

2 REPLIES 2
MMÜ
Frequent Visitor

Hi @v-jingzhang,

 

thank you for the supplied links. My guess would be that the cause is described in the thread The specified network name is no longer available (microsoft.com) as "transient errors". Unfortunately the recommendec solution from the Microsoft Docs (Transient Fault Handling (Building Real-World Cloud Apps with Azure) | Microsoft Docs) is to prepare your application to encounter such errors and just retry it.

So how exactly am I as a Power BI user supposed to do that? Wouldn't that be something the Power BI team needs to implement?

 

Best regards

MMÜ

v-jingzhang
Community Support
Community Support

Hi @MMÜ

 

It seems not a Power BI or Power Query issue. Did you set up any Firewall rules in Azure portal that will restrict the access to the database?

 

See if these links are helpful:

SQL data connection occasionally timing out for scheduled refreshes

The specified network name is no longer available (microsoft.com)

New Azure SQL Server Connection Error - Microsoft Q&A

 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors