When I refresh the data from an excel there are some sheets that give me an error. The Power Query have the new data but the Power BI desktop do not refresh it.
I think it is a modeling data error but I do not make any change till the last report.
OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)).
I can't reproduce it.
1. What changes did you make in the last report?
2. I would suggest refreshing the model in the Query Editor and then applying the queries.
3. If it's possible share the files with me?