Forum Discussion
wrong import of data from access file
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. ...
I checked datatypes and refreshed but the result has not changed. The data import is still wrong.
pnvinod
Helper I
Helper ICould you please share sample data of your table and also the corresponding data seen in power BI?
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