Forum Discussion
Is Power Pivot Needed?
I wasn't sure if this question belonged in a Microsoft Office community or this Power BI community. I chose here. I really tried searching for an answer on Google, and while there were some close ans...
HI LoremIpsum
There are certain reasons you should use powerpivot.
1. PowerPivot models can be imported into the PowerBI Desktop and SSAS Tabular. So, You can prototype your model in PowerPivot and can import the model to SSAS Tabular without recreating any new calculations.
2. The second benefit is you can load your Query data to either Excel Worksheet or Datamodel. Two options.
3. PowerPivot has its own set of data connectors which you can also use to load data to data model.
4. You can prepare pivot table reports on top of your powerpivot model.