Combining multiple files

[Anonymous]

Hi guys,

Not sure what I am missing here, but when I click Combine files, power query is only keeping the first file from the list. I need all the available files. Any suggestion?

[v-luwang-msft]

Hi @Anonymous ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[Thejeswar]

Hi @Anonymous ,

When you click on combine fiel, a new pop-up appears asking you to select the columns in each file. You can also skip this step.

As long as your files are of the same format, the combine is going to work automatically

PFB screenshots

I click combine in the above step.

The Final table look like as follows

The Pop-up that ppears when you click on combine is shown below

Hope this helps!!

[Anonymous]

Thanks @Thejeswar I am already doing that, but I don't have any option to select the columns that want. After clicking on the Combine button, Powerquery creates the function.

[Thejeswar]

Hi @Anonymous ,

This is the standard way Power BI reacts when you click on combine. Not sure why you are not getting a popup. 

I guess you are importing similar files from a folder. In such case, while you connect to the data source itself you get a combine option. Same is shown below

You have two options in combine, which you can select.

In case you are not loading from a folder, then give some more info on how the data is being imported. 

Regards,