Forum Discussion
How to extend Power BI service timeout limit
Super Userplease 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
Source
I 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.
- v-janeyg-msft
Community Support
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.
When I try to do that, I also get errors just as lbendlin. Mine says,
'CommandTimeout' are not valid options. Valid options are: 'CreateNavigationProperties.'
How are you avoiding the error or how would you use this valid option?
- lbendlin
"When I try to add any timeout options I get errors"
How are you trying to do that and what errors do you get?
