Hi, All
I have an excel file that scheduled to open->refresh a pq query->email->close.
The query I am running is an MS Exchange query. Basically just counting how many emails there are in a shared box.
Sometimes, this query errors out with "[DataSource.Error] The request failed. Unable to connect to the remote server". When this happens, the opened file is just stuck and fail to close.
Is there "on error resume next" equivalent in power query?
thanks
I have an excel file that scheduled to open->refresh a pq query->email->close.
The query I am running is an MS Exchange query. Basically just counting how many emails there are in a shared box.
Sometimes, this query errors out with "[DataSource.Error] The request failed. Unable to connect to the remote server". When this happens, the opened file is just stuck and fail to close.
Is there "on error resume next" equivalent in power query?
thanks