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
Microsoft ExcelMicrosoft SQL ServerMicrosoft ApplicationsOffice Productivity
Last Comment
Rayne
ASKER CERTIFIED SOLUTION
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
or
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
^^^ 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
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
In what form? If it's not a pivot table, you're probably better off with PQ.