How to work with Multiple excel file in Power bi.

[sandee]

Hi All,

i have been struggling in understaning, as how we can work in power bi when we have multiple excel file. 

i know i have to select the "Folder" option, then "combine and editing option", after this the normal transformation.

the problem is in only able to transformation in single file, do not know who take second file. can you please exp

[Anonymous]

The problem is not clear however I hopwe this link can help you - https://sqlitybi.com/loading-multiple-excel-files-from-a-folder-in-power-bi/