Forum Discussion
Power BI not Importing All Records
Microsoft EmployeeAnonymous 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.
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
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?
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.
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.