Forum Discussion
How to extend Power BI service timeout limit
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.
The following is what my query code looks like:
let
//Pull in a values from the parameter table
//Create the query
dbQuery = "Select * FROM table WHERE var1='" & Parameter1 & "' and var2 in ('" & #"Parameter2" & " ','" & #"Parameter3" & " ','" & #"Parameter4" & " ')",
//Get the data
Source = Sql.Database("server","database",[Query=dbQuery])
in
SourceI structured it like this so the query doesn't try to load all 30 GB.
When I try to add any timeout options I get errors and I cannot access the SQL server database pop up as janey has commented.
Hi, katherine_stz
This is the code after I use DQ mode to connect SQL and add 10min timeout when connecting, you can reference:
If it doesn't work, Please feel free to ask me.
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.
