Hello has there been any progress on the issue with scheduling refreshes of Denodo-sourced data. Similar to Tom, I am trying to refresh a dataset using our Gateway's Denodo connection. It fails frequently. The same dataset can be refreshed successfully in seconds.
Attached is the script from the advanced editor for 4 queries in the report:
let Source = Sql.Database("PLKFSQL10V\PROD2012", "EDM", [Query="SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;#(lf)SELECT GETDATE() AS Last_Refresh;", CommandTimeout=#duration(0, 0, 5, 0)]) in Source