Forum Discussion
Error while refreshing from service
We found the issue. We never stopped a second to check the basic configuration. The problem was the configuration of the ODBC where the Gateway is located.
Thanks!
I dont know if I am setting it wrong. I tried to do it in the specific table that's refrenced in the timeout error. I entered the advanced query editor and added the parameter. It looks like this:
let
Source = Odbc.DataSource("dsn=RamosDesa", [HierarchicalNavigation=true], [CommandTimeout=#duration(0,0,40,0)]),
VW_PROTOCOLOESTUDIOS_View = Source{[Name="VW_PROTOCOLOESTUDIOS",Kind="View"]}[Data]
in
VW_PROTOCOLOESTUDIOS_View
When I save that change however, I see an error with the table itself:
Expression.Error: 3 arguments were passed to a function which expects between 1 and 2.
Details:
Pattern=
Arguments=[List]
The Hierarcy function is already there in every query. Should i add the commandtimeout in another instance?
