10 Million Rows of Data Loaded into Excel ( **see updated version of this - link in description**)

If a member of your team or organisation says that Excel can't handle the amount of data you need to analyse then maybe they don't know about Modern Excel's power.

This video also highlights the importance of only bringing in the columns you need and the impact that "Cardinality" or uniqueness of data has on the resulting size (and performance) of the Power Pivot report

[davejl]

For those who are commenting negatively on this video, please understand what the purpose of this video is prior. Very useful to understand the impact of the nature of your data have on your file. The cardinality effect.

[ericaltf]

I didn't see the data actually loading in to excel. His column A looked blank.

[hieungo]

How do you export the 10 million records to a csv file?

[hourscold]

how to load data in new sheets if row exceeds excel rows. tia

[sgo.sergiog]

Can I read this saved data with Power Query in another worksheet ? I want to reuse a calculate column in another applications. Thanks a lot!

[willemlottering]

This isn't reading the data from a file or other data source with multiple columns.

[yashhirulkar]

the initial part of video is blur cant see the start of video...!

[DineshKumar-cubg]

How to load 3 gb of csv file in excel for making reports

[civilEngineering]

didn't work with me i'm using office 2016

[rgcabarth]

I am importing around 60000 rows from web link but power query has a limit of 1000 rows to import it...is there a wat to bypass this limit and import around 60000 rows that I need??

[ashishbehera]

concept was good, but i was not able to see this at my place ...my bad

[shivamsinghal]

Im sorry, but didnt understand properly.