wrong import of data from access file

[Fred99]

Hello,

I tried to import a table from a access file but all the column with numbers are null or have wrong numbers. I checked the file in the query editor and at this stage the numbers are correct. When I upload the file from the query editor to power bi all the numbers again wrong or 0. Also the product code which is formated as text is wrong (the product code are duplicated or put in the wrong row). Again the file in the query editor is fine once I uploaded it to power bi  the loaded data are wrong.

I have loaded several table to power bi but I never had this problem. Maybe someone has an idea of the reason of this strange behavior.

Thanks in advance

Fred

[pnvinod]

Please verify and change Datatypes for these columns as appropriate,

Then Refresh

[Fred99]

I checked datatypes and refreshed but the result has not changed. The data import is still wrong.

[pnvinod]

Could you please share sample data of your table and also the corresponding data seen in power BI?

[Fred99]

Hello;

I made another test. The table consists of over 60000 rows. I reduced the tabel to 5 rows and loaded the file in power bi and no error the data are correct. I reloaded the 60000 rows and the data are wrong. That means that in one or some rows datas which confuse power bi and let them make this strange behavior, but what can that be???

[pnvinod]

Sorry, I may not be able to suggest anything on this data related Issue