DISP_E_TYPEMISMATCH

[Fidzi8]

Hi, 

I would need advice. (I know there are enough topics with this problem but I still don´t know :/)

I create excell´s table as master data where i will download data from SAP every day. After 3 months I add today´s data to the last line table and I update powerBI - I get this mistake. 

I don´t know what I´m doing wrong. I´m just adding the same data to the same table. 

Thank you

Ondřej 

[MFelix · Accepted solution]

Hi @Fidzi8 ,

To what I can see this is related with formatting of some data, you can try to take out all the Changed Type steps from your query and check if this is letting you update the information.

On other issues that come accross errors similar to this is to keep the data in the query editor as text so without any change type steps and then on the format option for each column do the correect formatting, this will make the query editor result always the same no format errors, and pass that formatting to the "front end".