Forum Discussion

rushekkgadde's avatar
rushekkgadde
New Member
8 years ago
Solved

Working with multiple excel files as data source

Hi, is there a way to merge all excel files as separate sheets into one file and make a single connect into power bi, currently my queries are connected to single excel file, one query one connection,...
  • jthomson's avatar
    jthomson
    8 years ago

    Importing as a folder should work

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi rushekkgadde,

 

Here is a blog shows that get data from a SharePoint folder which contains multiple Excel files.

 

Regards,

Yuliana Gu