Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Help! Power BI not handling SQL query and Timing Out

Hi,   Super new here. My current position requires me to maintain some PBI dashboards up and running. Last week my problem started.   Dashboard was not getting updated automatically. Its crashing...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi, Ill try that.

     

    I did set it to 30 mins with no success (it crashes the pbi file).

     

    Currently I am running the querry in Microsoft SQL Server Mgmt studio, exporting the querry as csv file and importing it to my data model.

     

    Super counter productive... but its working for now.

     

    Best,

     

    Kurt

  • Anonymous's avatar
    Anonymous
    3 years ago

    From what I have googled arround and read in the comunity, I guess its an issue on how power query deals with a sql query versus ms sql server manager. Power query seems to load the entire tables before making any filterings and appendings and as one table is 11 milion lines, it cannot handle that load in a short time and simply times out. 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

From what I have googled arround and read in the comunity, I guess its an issue on how power query deals with a sql query versus ms sql server manager. Power query seems to load the entire tables before making any filterings and appendings and as one table is 11 milion lines, it cannot handle that load in a short time and simply times out.