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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors