Forum Discussion

piyushj's avatar
piyushj
Frequent Visitor
9 years ago

Power Bi Service Refresh - timeout expiration issue

Hi PBI Team,   We are facing an issue in power bi service as well as in desktop app. We have huge amount of data available in tables (>10GB). We are importing data using SQL Server database. Previo...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi All, 

 

I am experiencing this time out issue now.  its a import dataset and i dont see any duration parameter coded in the advance editor.  do we need to add it to the code.  also this issue is occuring suddenly. 

GilbertQ's avatar
GilbertQ
Super User
7 years ago
Hi there

what do you mean by the duration parameter?
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    GilbertQ,

     

    I mean the time out parameter that you set while connecting to any source.   You can see that in advance editor M code. 

     

     [Timeout=#duration(0, 0, 5, 0)])

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    I guess the timeout parameter can only be set if using SQL Server. But not sure if that will override the 5 hours timeout which is present on Power BI Service for any individual running query. Regards
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    In your query source settings there's an option to specify a timeout that is longer than the default one. But it looks as though even doing that would not solve the problem a lot of people in this thread seem to be having because Power BI simply cannot handle such large sets.

     

    I do find it surprising that in the age of "Big Data" things like this haven't been resolved. Just an hour so ago Excel completely fell over when I passed just 500K rows to it