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
manoj_0911
Post Patron
Post Patron

Connection Error While Refreshing Data in Power BI Desktop – Transport-Level SQL Error

 

Connection Error While Refreshing Data in Power BI Desktop – Transport-Level SQL Error

 

Dear Team,

I am encountering a recurring issue in Power BI Desktop while refreshing data from my SQL Server data source. Below are the details:


Issue Description:

While attempting to apply pending changes or refresh data, I receive the following error message:

OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: A transport-level error has occurred when receiving results from the server. 
(provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

As a result, dependent tables like DATE_TIME_V also fail to load.

 

manoj_0911_0-1752652317360.png

 


Environment Details:

  • Power BI Desktop version: July 2025

  • SQL Server data source : Import

  • Table involved: IVR_SUBHOUR_V

  • Internet/network connection: using home Wi-Fi to connect to corporate VPN

  • Occurrence: frequent

  • Report name: 08-CCC-IVA PERFORMANCE SUMMARY & DETAIL REPORT


Steps Already Taken:

  • Restarted Power BI Desktop and retried

Request:

Could you please help me identify the root cause and suggest a permanent fix for this transport-level error?

 

Please let me know if any additional logs or diagnostic information is required from my end.

 

Thank you for your support.

 

Best regards,
Manoj Prabhakar Selvaraj

4 REPLIES 4
v-echaithra
Community Support
Community Support

Hi @manoj_0911 ,

We wanted to follow up to see if the issue you reported has been fully resolved. If you still have any concerns or need additional support, please don’t hesitate to let us know, we’re here to help.

We truly appreciate your patience and look forward to assisting you further if needed.

Warm regards,
Chaithra E.

v-echaithra
Community Support
Community Support

Hi @manoj_0911 ,

We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

v-echaithra
Community Support
Community Support

Hi @manoj_0911 ,

Thank you @GrowthNatives  for your inputs.
We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

Thank you for your patience and look forward to hearing from you.
Best Regards,
Chaithra E.

GrowthNatives
Resolver III
Resolver III

Hi @manoj_0911 ,

You can follow below steps to solve this :

1. Use a Wired Ethernet Connection .

2. Reconnect VPN Fresh before opening Power BI.
3. Split Query: Limit the size of data from IVR_SUBHOUR_V using filters or parameters (e.g., only current month).
4. Check Query Timeout Settings:

  • Go to Data Source Settings in Power BI.

  • Click Change Source > Advanced options, and increase Command Timeout to 10+ minutes.

5. Client-Side Configuration

  • Power BI Desktop Options:

    • Go to File → Options and settings → Options → Data LoadUnder Global → Data Load, increase Background Data Timeout to higher value.


Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore More]

 

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.