Link to home
Start Free TrialLog in
Avatar of Rayne
RayneFlag for United States of America

asked on

powerpvt vs powerQry

Hello All,

What is the basic difference between PowerPivot and power query – I am pulling data from multiple sources (huge csv files and other formats) and then i  would need to join them and then manipulating them and putting them in one sheet of excel.  Which one will be better in this case? Power pivot or power query
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
putting them in one sheet of excel

In what form? If it's not a pivot table, you're probably better off with PQ.
^^^  Along these lines, it might not be a bad idea for you to paint us a picture of what exactly your business needs are, and how large these files are, as there are other solutions that may be more ideal.
Avatar of Rayne


Thank you, I was out sick so sorry for the delay