Forum Discussion

confpbiemb1's avatar
confpbiemb1
New Member
6 years ago

DM_GWPipeline_Gateway_TimeoutError // Datasource: Excel

I have the following error message when updating my published report, after 2h:

An error occurred while processing the data in the dataset.

Associated with the code: DM_GWPipeline_Gateway_TimeoutError.

I tried to use the following command:

let
Origen = Excel.Workbook(File.Contents("\\RutaCompartida\\ArchivosExcel.xlsx"),null,[CommandTimeout=#duration(0,2,0,0),Connectiontimeout=#duration(0,2,0,0)])

However he throws the following to me:

Expression.Error: Cannot convert a Record value to Logical type.
Details:
Value
CommandTimeout-0.02:00:00
Connectiontimeout-0.02:00:00
Type[Type]

You would say that the command for TimeOut is associated within a SQL Datasource, for an Excel Datasource. What command would you use to modify the "Timeouts" in Update?