Forum Discussion

justin777's avatar
justin777
Frequent Visitor
8 years ago
Solved

Possible reasons for SQL Timeout on loading a view on Import

Hi Guys,  I am stuck on solving this problem.  So I have 5 views, and 1 of them are always stuck on loading when I apply to changes.  It is always stuck on "Waiting for (SQL Server & DB)"    ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi justin777,

     

    Did you add some complex steps in query editor? If there are too many steps or too complex steps the issue might occur.

    In addition, the option “Allow data preview to download in the background ” could affect the performance as well. You can disable it and have a try agagin.

     

     

    By the way, what is your version of your desktop? Here I suggest to use the latest vision to work with. (Version: 2.60.5169.3201 (July 2018) )

     

    Regards,
    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi justin777,

 

Did you add some complex steps in query editor? If there are too many steps or too complex steps the issue might occur.

In addition, the option “Allow data preview to download in the background ” could affect the performance as well. You can disable it and have a try agagin.

 

 

By the way, what is your version of your desktop? Here I suggest to use the latest vision to work with. (Version: 2.60.5169.3201 (July 2018) )

 

Regards,
Frank

justin777's avatar
justin777
Frequent Visitor
8 years ago

Hi Frank,

Thanks for the reply. The "Allow data preview to download in the background" actually help the performance a bit especially when just editting the query but I realize the bottleneck is really from the server. I thought it is some kind of bug or an option I have not yet discovered but the problem was pretty basic. The SQL Server can't handle the query with the default timeout limit, when I extended the timeout to 90 mins, it works fine after waiting for at least 20 mins. 

I'm using the latest Power BI Desktop just to be sure I don't get any weird bugs along the way