Forum Discussion
using Power Pivot
Office 365, Windows 10 I have a large export from a database that's bigger than Excel can handle (too many rows for xlsx or csv). From what I've gotten out of info on Power Pivot, it seems that I n...
Hi Steven, what file extension does your export have?
Or do you need to connect to the database directly using Power Query?
I have the options of exporting to Excel 2003, Excel 2007, csv, html.
I've tried them all, but they stop exporting before giving me any results. At least the html option showed me there were almost 1.3M records.
The export I'd been using was Excel '07 until the file got too big.
- If connecting directly to your database is not an option then maybe split the export into 2-parts based on date? and then use Power Query to join the 2 exports back together and load to Power Pivot.
If I could split the db by date, I could move on to bigger things.
Unfortunately, all I can select from is the export's name, type (xls, etc.), and folder to save the file.
I've looked around the settings and controls, but haven't found anything that can help.
There is no joy in this Mudville!