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]
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.