Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Power BI not Importing All Records

Hi All,    I've got a very simple data table (although very large) from Access that I've tried to import into Power BI, however not all of the records are coming over. I don't have any filters on t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

I'll try Power Query.

 

Just an update - I reuploaded my data table and it stopped at the exact same place. I haven't done a lot of testing, but it looks like PowerBI can only import 1,048,501 records in one table. 

pqian's avatar
pqian
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Anonymous This maybe related to an issue we uncovered recently around error handling during importing. I suspect that around 1 million rows there is an error and we aren't handling it correctly. This issue should be fixed soon.

 

Meanwhile, here are somethings you can try:

1. Split into multiple tables with Skip+Top, see if you can get to all the data that way

2. Add a Table.Buffer() to your query, that may have better error handling but will require large amount of memory.