using Power Pivot

Question

Office 365, Windows 10I 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 need to get the db to give me a larger csv somehow,&nbsp;or is there a way to have Power Pivot "intercept" the data &amp; have it available to Excel after the export?

wyn hopkins · Answer

Hi Steven, what file extension does your export have? Or do you need to connect to the database directly using Power Query?

deleted · Answer

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.

deleted · Answer

The export I'd been using was Excel '07 until the file got too big.

wyn hopkins · Answer

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.

deleted · Answer

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!

Forum Discussion

using Power Pivot

Share

Resources