Forum Discussion

manoj_0911's avatar
manoj_0911
Kudo Commander
1 year ago
Solved

Power BI Desktop Refresh Fails with SQL Error: "Transport-level error... connection was forcibly clo

  Power BI Desktop Refresh Fails with SQL Error: "Transport-level error... connection was forcibly closed by the remote host   Hi Experts, I'm facing an issue when refreshing my Power BI Desktop ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi manoj_0911,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community. Thanks to RemyO  fpr prompt and helpful response.

     

    Yes, that would be the recommended approach. It helps by:

    • Using a refreshed dataset hosted in US.

    • Avoiding VPN-based slow SQL queries.

    • Building reports faster in India using cached data from the Service.

    Thanks & Regards,

    Prasanna kumar

     

     

RemyO's avatar
RemyO
Resolver I
1 year ago

1) You cant prevent it. Your connection may be to slow or unstable, hitting time out limits.

2) import less data Do not import unused columns and/or rows

3) maybe and yes. Also the speed of your SQL server might impact it. And whether you import from a view or tabel (table is better)

 

But why dont you set a refresh from service running from US ? So publish the dataset. Set your refresh settings

Then connect your Desktop to the refreshed dataset.

 

This would be the best solution to your performance because you dont have to refresh anymore