Power Query is also known as ‘Get and Transform’ in Excel 2016.įor this post I’ll be using sales records with the following fields: Region, Product, Date, and Sales. To accomplish this, I’ll use two Excel tools: Power Pivot and Power Query. To make things more interesting, I’ll import data from 20 different text files (.csv) with 2.5 million records each. In this post I’ll debunk this myth by creating a PivotTable from 50 million records in Excel. Actually, the right myth should be that you can’t use more than 1,048,576 rows, since this is the number of rows on each sheet but even this one is false. A common myth I hear very frequently is that you can’t work with more than 1 million records in Excel.
0 Comments
Leave a Reply. |