Forum Discussion
600 Second Timeout Setting?
Super UserThe top recommended post to the right has the solution:
Function Odbc.DataSource error with Timeout settings
As mentioned in the documentation, you can use "ConnectionTimeout":
Source = Odbc.DataSource("dsn=Production", [HierarchicalNavigation=true, ConnectionTimeout=#duration(0, 0, 15, 0)])
Thank you so much, I didn't realize those were over there! I will definitely pay more attention to that area in the future.
Also, thank you for the suggestion! I am having trouble figuring out where to put that line. I looked through the post you linked (as well as several others that seemed related from the side bar), as well as the docmuentation you linked, but I don't fully understand what I'm seeing in the other solutions and it looks different from mine. I also tried adding the line or pieces of it in various places within the query code, but everywhere I tried I got an error that it wasn't valid. I realize you can't see what I'm seeing, I'm nervous about sharing the query code or a screenshot because I'm not sure what information might be sensitive. Would you be willing to suggest where I should put the line of code? Or what info you might need to be able to tell me what to do?
- AlexisOlson
Usually, pasting the M code from the Advanced Editor works well provided you change or redact any names or other sensitive bits that might be within filters or column names since the query just says how to get and transform the data rather than what the data actually is.