Forum Discussion

Copper Contributor

May 17, 2017

Solved

Misisng combine comand in new query from folder

Hi, I have a 3 excel file in a folder. I want to import them in a data model through New Query from folder. When I select the folder and open the link, I get the 3 files with "binay" in content c...

BI & Data Analytics

tips and tricks

Yury Tokarev
May 18, 2017
Hi Michele,

you need to create a custom column and put =Excel.Workbook([Content]) in it. Then expand tables at the top-right of the custom column header. It will give you a list sheets or tables available in the file. You can filter out the required ones, then expand tables in a new column once again.

You can refer to https://www.poweredsolutions.co/2014/11/21/combining-data-from-multiple-excel-workbooks-with-power-querythe-easycompletepower-bi-ready-way-2/ for more details.

Newer versions of Power Query handle the task of combining excel files automatically by adding some custom functions.

Hope this helps

Yury

Michele Marco Schiavon

Copper Contributor

May 18, 2017

Hi Yury,

thanks for the reply. I tried to click on the 2 arrows button but I get an error. And with the right click I don't find the option to combine...sorry pictures are in italian.

I select the 3 files I want to insert with query, I select modify to enter the query editor, then those are the options with right click on "2 arrow" button, and if I just click on it i get that error message.

Yury Tokarev

Iron Contributor

May 18, 2017

Hi Michele,

you need to create a custom column and put =Excel.Workbook([Content]) in it. Then expand tables at the top-right of the custom column header. It will give you a list sheets or tables available in the file. You can filter out the required ones, then expand tables in a new column once again.

You can refer to https://www.poweredsolutions.co/2014/11/21/combining-data-from-multiple-excel-workbooks-with-power-querythe-easycompletepower-bi-ready-way-2/ for more details.

Newer versions of Power Query handle the task of combining excel files automatically by adding some custom functions.

Hope this helps

Yury

jdrennen
Copper Contributor
Aug 25, 2020
Yury Tokarev Good Afternoon,

I tried to click on your link regarding the Power Query Error you mentioned but the link is broken.

Any assistance would be a huge help because I am running in tot he same issue.
- SergeiBaklan
  Diamond Contributor
  Aug 25, 2020
  jdrennen
  
  Please check Combine files (binaries) in Power BI Desktop That's for Power BI Desktop, but i Excel connector works the same way.
Michele Marco Schiavon
Copper Contributor
May 19, 2017
Hi Yuri,

thanks again for the answer. Link was very useful and a great blog discover.

I managed to load the files!! :)

Ciao