Showing results for 
Search instead for 
Did you mean: 

Refreshing data error

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)).

Status: Needs Info

Hi @GonçaloCardoso,


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?


Best Regards,


Established Member
Status changed to: Needs Info