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?
just stick it into power BI and do everything in there
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).
@ObiWomKenobi started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
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?