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":"https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails"}},{"code":"Microsoft.Data.Mash... |
Cluster URI: | WABI-US-NORTH-CENTRAL-B-redirect.analysis.windows.net |
Activity ID: | 571c70ab-a8b2-4a01-92a9-b45f9d9eb90c |
Request ID: | f924a034-483c-f45a-4a23-a9e737f08847 |
Time: | 2020-11-23 16:43:04Z
|