Forum Discussion
Connection Error While Refreshing Data in Power BI Desktop – Transport-Level SQL Error
- 1 year ago
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 Load. Under 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]
I have followed the solution steps but got below error
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 - The semaphore timeout period has expired.).
- leap9 months agoRegular Visitor
Correction! When used the Wired Ethernet Connection it worked!!!
Thank you.