Data source error{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":

[lottieritchie]

Hi, 

I am getting the following error when refreshing a data set that has previously been running for months without any problems. 

I know nothing has been changed as I am the only person within our company who administrates our Power BI account and I am on maternity leave! I have other datasets linked to the same source data and tables which are all running fine without any issues. 

Does any one know how I can fix this? 

Thanks 

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":"ODBC: ERROR [22018] [MySQL][ODBC 5.3(a) Driver][mysqld-5.6.35]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Odbc"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"dsn=CPServer"}},{"code":"Microsoft.Data.Mashup.ValueError.OdbcErrors","detail":{"type":1,"value":"#table({\"SQLState\", \"NativeError\", \"Message\"}, {})"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: question

[Icey]

Hi @lottieritchie ,

Is your data source MySQL?

Which gateway are you using?

What's the difference between this dataset and others using the same data source?

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.