Excel Load help

[vjnvinod]

hi,

i have 3 excel, would like to load this from a folder into power BI, how do i load this without combining, so that it gets loaded as 3 differnt tables in power BI

IPO TMT 2013-Aug 2018.xlsx

Tech M&A 2012-2018 2Q.xlsx

VC TMT 2009-2Q2018.xlsx

[v-yulgu-msft · Accepted solution]

Hi @vjnvinod,

There is no direct way to load multiple files from a single folder as separate queries without combing into desktop.

You may need to load the three excel files one by one into desktop. Alternatively, as a workaround, you can load them together then split the single table into three tables via duplicating and filtering. For details, please see: Splitting a table into two based on column value

Best regards,

Yuliana Gu