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 li...
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.
lbendlin
Super User
Super User"When I try to add any timeout options I get errors"
How are you trying to do that and what errors do you get?