Forum Discussion
How to extend Power BI service timeout limit
I have a report using DirectQuery on an extremely large dataset in SQL (over 30 GB). I'm running into a timeout issue on Power BI service because some queries take up to 10 minutes to load and the limit seems to be a little over 200 seconds. I have access to Premium/Pro. I've found some similar questions on the forum but no clear answer. How can I extend this limit?
12 Replies
In your data source definition you can add both Connection Timeout and Command Timeout option modifiers. Note that there is a hard 600 minute limit on the service.
This doesn't seem to be working for me. I'm using direct query and have this line of code: Source = sql.database('server name', 'database name', [Query = dbquery]) where dbquery is defined in a previous line so as to not import the entire dataset in (very large, would take forever). It gives me errors saying that I am passing in unacceptable parameters when I add the commandtimeout parameter. Any suggestions on how to work around this?
please show what you have tried to add there.
As a side note - in Direct query mode any response over five seconds will result in unhappy users. Make sure your data source is fine tuned to the queries generated by Power BI. Indexes, statistics, the whole thing.
Hi, katherine_stz
Have you tried entering timeout minutes when connecting?
Like this:
Best Regards,
Community Support Team _Janey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-janeyg-msft ! Can I ask if this means that this setting will be carried over to Power BI Service? We are connecting to an on-prem SQL Server using a Gateway.
The answer is a definite maybe. If you specify it in Power Query then it will most likely be honored unless your data source enforces its own (lower) limits.
