Forum Discussion

Ashish_kumar12's avatar
5 years ago
Solved

How to Merge More than 15 excel files in Power Query

Hi There ,

 

Hope you are doing  well.

 

Can anyone please tell me that how can i merge 15 excel (.xlsx)files in one file in Power Bi desktop ?

I have laod the folder from the source and all the files are appearing however i am not sure what will be the next step to combine all those files .

E.g i have 15 excel files available in "XYZ" folder , I want all those file to be consolidated in one File and Load their data into Power BI Dekstop .

 

Regards,

Ashish