You are reading a single comment by @ObiWomKenobi and its replies. Click here to read the full conversation.
  • A slightly technical question on Power Query/Power Pivot.

    We get big csv files, 10,000,000 rows plus, and point PowerPivot at them and do the manipulation in PowerPivot.

    Would there be any performance improvement in importing the csv into SQL server and then pointing PowerPivot at that?

  • Most of the stuff we're doing is generating pivot tables from the data so PowerPivot is the best option for that (plus the Excel style formulas are much easier to work with).

About