Avatar of Rayne
Flag 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
Microsoft ExcelMicrosoft SQL ServerMicrosoft ApplicationsOffice Productivity

Avatar of undefined
Last Comment

8/22/2022 - Mon
Jim Horn

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Rory Archibald

putting them in one sheet of excel

In what form? If it's not a pivot table, you're probably better off with PQ.
Jim Horn

^^^  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.

Thank you, I was out sick so sorry for the delay
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy