Power BI refresh error

[Anonymous]

Hi Boddies,

Recently, I almost always got following failure on scheduled Power BI refresh. Does anybody have solution or idea on it?

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":"Invalid placeholder or value in format string. Underlying error message: We were unable to find a database provider with invariant name 'MySql.Data.MySqlClient'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: Date_Axis_ActionTarget.

[Anonymous]

Per above hint, I double check a suspicous date column, there is non-date text in some rows. So managed to clean the column in data preparation phase. Then such error never happed till now. 👌

[Anonymous]

Hi olgad,

Yes, I bascially have the same consideration. After re-look at the data table, there is date column with many records filled with fully unknown string. I guess it is a cause. I attempted to ask upstream to carefully shape the data. I will come back with further update.

[olgad · Accepted solution]

Hi, it doesnt like this value  -2147467259 in the column type 1 in Date_Axis_ActionTarget, what is the data type of that column?