Forum Discussion

manoj_0911's avatar
manoj_0911
Kudo Commander
1 year ago
Solved

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 Ser...
  • GrowthNatives's avatar
    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 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]