Why can't I multi-select data source objects from Excel from Sharepoint folder

Hi  i2rsantos ,

When you enter the Power Query stage, click Transform data.

Then click on the column, and check the table to be left according to your own needs, so that you can filter out the desired table.

If you want to append multiple tables into one table, you can select the red arrow to form a table:

Notice:

The structure, column names, etc. need to be consistent between tables, otherwise an error will occur.

If it is not the above problem, can you provide the error details of Query1.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.