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 the data.

 

Out of the 1.65Mil records that I'm trying to import only 1.05Mil records are being imported. 

 

I know this is very vague, but I don't think there's many "moving parts" to my table, it's just big. Has anyone experienced this? 

 

Thanks in advance!

Need Help

15 Replies

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

    I haven't heard anything like this. Definitely a serious issue if this is a bug. Can you use "Send a frown" button from the workbook that's missing data, and report the issue that way?

     

    Another thing to try: PowerQuery for Excel, see if the issue repros there.

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

  • MissyShealy's avatar
    MissyShealy
    Frequent Visitor
    6 years ago

    Hello. I am experiencing the same problem.

     

    I am new to Power BI Pro Desktop.

     

    I imported an Excel file with ~ 212,000 records. Only 210,594 imported in along with a pivot table. I tried a larger file earlier and had the same experience. I thought my smaller file (212,000 records) would import in fine.

     

    I have verified that I have the Pro version and currently have 0 MB of 10 GB used. 

     

    What could I be doing wrong?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      You know what helped me is to make sure the data that you're importing is in a table on your Excel sheet. 

       

      That might help. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    I am also experincing the same issue, was your issue resolved? If so, please let me know how.