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
ryans's avatar
ryans
Icon for Helper I rankHelper I
10 years ago

Anonymous it can definitely handle more than 1,048,501 records so don't discount it yet! I have tables with 5 mm + records I am working with.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

ryans Well that's good news and bad news then. I'm happy to hear that PowerBI should be able to handle the size, but now I'm left with my original problem. :catsad:

 

I hope it's what pqian said and it should be fixed soon.

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

    Anonymous Give Table.Buffer a try, if it is the issue I mentioned, then it means at 1mil rows the server returned an error, you still need to go chase that down.

     

    Actually you can use any function that breaks folding to the DB and require buffering rows locally. A simple split column should do it too.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      pqian I tried giving Power Query a try and got the following message:

       

      The query cannot be completed. Either the size of the query result is larger than the maximum size of a database (2 GB), or there is not enough temporary storage space on the disk to store the query result.

       

       

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

        That exception is coming from the Access DB...Can you take a screenshot of the error? Maybe your access file is located on a disk that's out of space?