Forum Discussion
Power Bi Service Refresh - timeout expiration issue
I can try with smaller dataset by using only few months of data.
But once I use all the months again, my dataset refresh time will increase and it will hit the timeout issue again.
Regards
That would indicate that due to the data size something is causing an issue.
Have you had a look at the Power BI Premium Capacity App to see if you run out of allocated memory during the dataset refresh?
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.
- Hi there
what do you mean by the duration parameter? 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)])
- 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
- Also, I have got this confirmation from Microsoft team that there is a limit on query timeout of 5 hours. Since I was using SAP HANA DB and there is a query which runs for 10+ hours. It runs fine on Desktop, but fails on Service due to this timeout issue. Regards
- Hi there
That is correct, you have to make sure it finishes within the 5 hours to get it refreshing. 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