Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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 @Anonymous

 

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
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.