Forum Discussion
Different DAX process in PowerPivot and PowerBI?
Hello, I have a model in PowerPivot using DAX. Data from SQL Server. It takes 7 minutes to refresh the model. I imported it to PowerBI, 0.5 minute to refresh. Is DAX processed differently in Po...
BhaveshPatel
Super User
Super User
The Version of the Powerpivot is important is deciding the speed. The other benefits of PowrBI is that it gets updated every month and have more bug fixes. The DAX processing is similar to PowerBI as both runs on the same Vertipaq Engine.
PowerPivot from Excel 2010 and 2013 are slower than Excel 2016 and PowerBI. I have personally experienced that sometimes PowerPivot loads data more faster than PowerBI. However, You can check the health of your model in DAX Studio, a free Excel Add in and Standalone product.