Forum Discussion
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?
1 Reply
- amitchandakSuper User
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