Forum Discussion
Power Bi Service Refresh - timeout expiration issue
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
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