Power query?

Hi, I have many files and one directory and they are all the same except the data in them. I am wondering if I am able to use power query or something similar that would allow me to combine certain data in these files and chart it.  The data is all in the same sheet but the file has many sheets.

I have never used power query.

Grateful for your help.
Thank you
pdvsaProject financeAsked:
Who is Participating?
 
xtermieConnect With a Mentor Commented:
Yes Power Query would do that for you.
Very interesting and helpful reading material here:
https://powerbi.microsoft.com/en-us/guided-learning/?ui=en-US&rs=en-US&ad=US
0
 
pdvsaProject financeAuthor Commented:
Hi, thank you for the response.

Is power BI another same for Power Query?
0
 
pdvsaProject financeAuthor Commented:
I mean are they the same?  Typing from phone
0
 
pdvsaProject financeAuthor Commented:
Thank you
0
All Courses

From novice to tech pro — start learning today.