DM_GWPipeline_Gateway_TimeoutError // Datasource: Excel

[confpbiemb1]

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?

[amitchandak]

@confpbiemb1 , there is some relative patch coming from excel. Can you check the source? I doubt excel is missing or renamed or folder is not correct.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot