hard20 pts · first answer countsexcelpower-querypower-pivot

Loading big data without a worksheet

A Power Query result has 6 million rows. How should you load it so you can build pivots on it?

A.Close & Load To > Table on a new worksheetB.Close & Load To > Only Create Connection, plus Data ModelC.Split the query into six sheets of about a million rows eachD.Copy the rows from the preview into a sheet

Discussion 0

Join free to post in the discussion.

Loading big data without a worksheet

Discussion 0

Related questions