Forum Discussion
Multiple Excel sources and many products
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
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
Thanks, CheenuSing.
