If I'm fine with doing everything in PowerPivot, aside of future proofing in case I may want to edit queries in the future, are there any reasons to put Power Query buffer in between my data source (SQL) and Power Pivot? Does it make the refresh faster?

I have a bunch of calculated columns in power pivot that I could move to Power Query, but I wasn't sure if the data model will benefit from it.


Personally I prefer to go via Power Query just for future proofing - I think that is reason enough. With that layer in place, you can do some extreme changes in the PQ layer (e.g. switching source from SQL to files, any kind of data cleansing logic you need) which are often totally disruptive with PP alone.

Note if you are on Excel 2013 and not on automatic updates, there are some updates needed, ref:


Typically calculated columns in PQ are be easier to write, debug, test, maintain and document, compared to the equivalent in PP.

Your Answer

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.