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

Dataflow fails to refresh

We are able to query the data via the dataflow using SQL server & Oracle RDBMS. Refreshes fail with the same message:

Error: AzureBlobs failed to get the response: 'The underlying connection was closed: An unexpected error occurred on a send.'. Request ID: a3c01f8f-b62a-121b-4666-15daae80c615 Activity ID: 88e873ab-1fb5-4f1a-8ac5-e08c3de34fa9.

 

Anyone have a fix for this? Searching on Google for Error: AzureBlobs failed to get the response: 'The underlying connection was closed: An unexpected error occurred on a send returns results for a certificate issue or a network issue

4 REPLIES 4
Frequent Visitor

Hi, thanks for asking.

We are using SQL Server and Oracle as our sources. Both refresh without issue via the On-Premise data gateways. The issue arrises when we attempt to refresh the dataflows built upon the datasources. I am thinking the issue may be that we do not have an account with the Azure Data Lake for the Common Data Model.

Hi @Jack2of3,

What type of connection are you worked? On-premise or online? (e.g. on-premise: SQL server installed in local device or VM, online: Azure SQL)

If you are working with a report that contains multiple connection modes with advanced operations, it may cause the issue to verify the credentials.
Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Community Support
Community Support

Hi @Jack2of3,

What type of data source are you test? did this issue appear on all of your data sources? Have you tested with other authorizations credentials or other devices? 

Please provide more detailed information about your operation steps and error message to help us clarify your scenario:

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Super User IV
Super User IV

@Jack2of3 , this can be because of few reasons. Port or IP access issue. Connection timed out.

Refer if this can help : https://www.fourmoo.com/2019/02/13/why-is-my-powerbi-dataflow-refresh-failing/

 

Or this for sql server : https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-824-database-eng...

 

If needed you can log ticket at - https://powerbi.microsoft.com/en-us/support/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors