Forum Discussion

jeffhadley's avatar
jeffhadley
Frequent Visitor
7 years ago
Solved

Enterprise Gateway - Cannot connect to the mashup data source

I have a data set that utilizes the Snowflake connector, as well as a connector to a file list in SharePoint.  In the past few weeks, I've begun receiving the following error when attempting to refre...
Need Help
  • jeffhadley's avatar
    jeffhadley
    7 years ago

    I figured out the issue. While PBI Desktop can navigate Snowflake's different schemas correctly, apparently the PBI Gateway cannot. Once I changed the data sources to all be from the same schema, the gateway was able to refresh without issue. I'm not sure why we utilized different schemas in the first place, but I'll keep this in mind down the road.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I have the same issue. Ther report refresh without any probmles on my desktop, however, one I pulish it to the PBI service the detaset will not refresh.

Unable to refresh dataset :  my report is not refreshing. My dataset uses data gateway, data source credential has admin access, Gateway is ON and schedule refresh is also on. I am still working on this issue to find a solution, and in the mean time I would really appreciate  of my usergroup input, suggestions, workaround etc.


here is the error msg:
Last refresh failed: Fri Nov 30 2018 10:16:15 GMT-0800 (Pacific Standard Time)
Cannot connect to the mashup data source. See error details for more information.Hide details
Underlying error code: -2147467259 Table: Invoice Totals by Cust and Product.
Underlying error message: MySQL: Fatal error encountered during data read.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: MySql
Microsoft.Data.Mashup.ValueError.DataSourcePath: 00.00.00.000;xxyyss
Microsoft.Data.Mashup.ValueError.ErrorCode: -2147467259
Microsoft.Data.Mashup.ValueError.Message: Fatal error encountered during data read.
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error