Forum Discussion
Solved
Multiple Excel sources and many products
Hi experts, I have four years of sales data on over 600 products. All of that data is in 45 Excel spreadsheets by month. There are all kinds of things I'd like to do with this but the most import...
It is better to combine the 45 excel sheets into a single one and then import into Power BI
Which version of Excel are you using. Make sure the version you are using is able to accommodate all the data into a single sheet in the combined excel file. Otherwise you will have formulate you own strategy of combining few excel files into one and hence have a limited number of excel files to be imported.
If you are loading mutiple excel files of some data structure then you should append the data from each file to the data model and not create as different tables in the model. Check out on appending data to existing data model.
Cheers
CheenuSing