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

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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    pqian I just ran the opened the database in Access and it didn't throw an error. I've also not said this because it's the Power BI community but my company also has Tableau and when I connect the table in Tableau I don't get an error either.

     

    Sorry, I'm new to the "Power" Apps (PowerQuery, PowerPivot, PowerBI) and I'm sure I'm not being as helpful as someone who's a pro at them.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    pqian Scratch that. It loaded the table fine but when I tried to go to the last record it threw the error leting me know that either the size of the table is larger than 2GB or I don't have enough space on my disk.