Best way to input data

[nataliesmiy1357]

Hello!  I am trying to create a report to show the trend of our companies data.  I'm not sure the best way to go about creating a database/excel sheet to input into PowerBI in the best way.  

This is currently how we have the data in our excel sheets for each year (I have a different file for each month of every year....)

We want to report on Total Assembly and Operations for each plant/line (column B) for each month (I get seperate files for each month)  But when I input this into PowerBI, It's not receptive to combine all of the previous years/months together.  

Hope this makes sense, and if not, I can help answer more questions!  Thanks in advance

[Power5]

To get the files to combine together you need to create a folder. Once you have the folder created, you can insert all the files into it BUT they have to be all in the same format. As in, same column names, and data types. Once you have that established you can combine the files together in power query. 

Here is a helpful video attached for reference.  

Mark this as a solution if this helps!