Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

mashup data source error in gateway (only) refresh

I have been struggling for weeks trying to resolve an error I am receiving when refreshing my dataset via a gateway (on-prem or personal).  Everything works fine from Power BI Desktop, but when publi...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Much to my dismay, the promised gateway changes that were expected to address this failed to do so and my specific issue was ultimately deemed by Microsoft as unsupported by the gateway.  My workaround was to completely redesign my approach to identifying the reporting period in a less than ideal hack.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I also have a mashup error on some of my refresh in powerbi service with my gateway (i have a cluster of 3 servers).

 

The 3 nods on my cluster were update last week with the last version of the gateway.

 

Something went wrong

There was an error when processing the data in the dataset.

Please try again later or contact support. If you contact support, please provide these 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":"Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"11"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"chg-dataws;datastore"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: rls UserPermissionsMapping.
  • Cluster
  • Activity 
  • Request 
  • Time2020-03-27 15:51:51Z

 

Anyony can help?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi I had the same problem.

I got message: UnderlyingErrorMessage","detail":{"type":1,"value":"Information is needed in order to combine data"}}
And it was connected to how I combine the data. In power query I couldnt merge data form table (data from computer disc C) and form different table (form jira or from sharepoint) even privacy level was the same.
I just didnt merge this data in power query, I did it in DAX by "related", and then refresh is working ok.