Showing results for 
Search instead for 
Did you mean: 

Dataset Refresh Error with Nov 20 Gateway Release - "The underlying connection was closed: Could not

See error message in text below.  Starting occuring 11/18th after our Gateway was updated to Nov 20 release.


My desktop solution has a few queries; the main one being a folder query called Powershell to extract text files.  Within the steps of this query, I merge a team member table  and other excel file data too.

The team member table source is from a PowerBI Flow.


The flow works fine and refreshes

The team member table by itself refreshes fine

The 'folder' query - refeshes fine within the Desktop

.... but produces the error found in the description below within the service


Through process of elimination; I found the error happens within the query execution, at the part where it merges in the Flow team member data.  


I've re-archietected my query flow to exclude that merge and do the work inside the model instead.  Now the solution refreshes without the error.


I am not an admin in either the service or the gateway and I dont know if there is simple configuration to change or not.


Last refresh failed: Mon Nov 23 2020 10:43:04 GMT-0600 (Central Standard Time)
There was an error when processing the data in the dataset.Hide details

Data source error:{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":""}},{"code":"Microsoft.Data.Mash...
Activity ID:571c70ab-a8b2-4a01-92a9-b45f9d9eb90c
Request ID:f924a034-483c-f45a-4a23-a9e737f08847
Time:2020-11-23 16:43:04Z


Status: New
Community Support



You may keep an eye on the Awareness.