Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power BI refresh error

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.

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

3 Replies

  • olgad's avatar
    olgad
    Resident Rockstar

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.

     

  • Anonymous's avatar
    Anonymous
    Not applicable

    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. ğŸ‘Œ