Forum Discussion

andi2333's avatar
andi2333
Helper I
1 year ago
Solved

Combining excel files from a sharepoint folder

Hi there,

I am still quite a newbie to Power BI and I believe that my issue would not be a big problem to most of you.

 

I connected to a sharepoint folder and successfully filtered for the files I would like to combine in Power Query.

 

But when I now close & apply this selection, these files are not combined. How do I do this?

 

Thanks a lot!! 

 

Need Help
  • zenisekd's avatar
    zenisekd
    1 year ago

    You need to expand those files first. Usualy there is a little icon with two arrows heading away, if you click it, it lets you expand the data inside the files. Before the load you should see the real record lines in power bi, not the file details.

1 Reply

  • zenisekd's avatar
    zenisekd
    Super User
    1 year ago

    You need to expand those files first. Usualy there is a little icon with two arrows heading away, if you click it, it lets you expand the data inside the files. Before the load you should see the real record lines in power bi, not the file details.