cancel
Showing results for 
Search instead for 
Did you mean: 

Error when setting up Gateway Data Refresh

There is no error when the data refresh is done through PowerBI Desktop. The dataset includes a query to SAP BW (import mode) and excel files from a Sharepoint folder. Here's the error message when refreshing the data from the Gateway: Cannot connect to the mashup data source. See error details for more information. Please try again later or contact support. If you contact support, please provide these details. Underlying error code: -2147467259 Table: Actual Costs. Underlying error message: The key didn't match any rows in the table. DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259 Microsoft.Data.Mashup.ValueError.Key: [Id = "ZPS_M03/ZPS_M03_Q004"] Microsoft.Data.Mashup.ValueError.Reason: Expression.Error Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net Activity ID: 48464344-c59b-4e31-aa29-11244e6f84c7 Request ID: 1644e684-ca7f-b104-c0ec-7a5974c1daab Time: 2019-01-07 11:40:59Z
Status: Needs Info
Comments
Moderator

Hi @jraymundo,

 

Please share detail gateway logs with us. You can upload them to your OneDrive and send the share link to me via private message. 

 

To enable the Mashup logs for the Gateway service on the Gateway machine then repeat steps to reproduce the issue:

  1. Stop Gateway service PBIEgwService. (look at task manager to locate the service)
  2. Open the file in a text editor like notepad: C:\Program Files\On-premises data gateway\Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config 
  3. Search for "MashupExtendedTracing" in the file 
  4. Update the flag "MashupExtendedTracing" to True as the following: 

                     <setting name="MashupExtendedTracingserializeAs="String"> 

                           <value>True</value> 

                     </setting> 

     e. Using the Gateway Configurator to enable the "Additional logging". 
     f. Restart the service

 

Also please provide with updated RequestID with us. 

 

Best Regards,
Qiuyun Yu 

Moderator
Status changed to: Needs Info