Rayne
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
^^^ 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.
ASKER
Thank you, I was out sick so sorry for the delay
In what form? If it's not a pivot table, you're probably better off with PQ.