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

[i2rsantos]

Hello,

I want to use an Excel spreadsheet that sits in a Sharepoint folder as a data source for my Power BI Desktop report.  I was successfully able to get to the point in the image below (after following instructions on YouTube) where I can select the data objects that I want to include in my model.  I want "BMESData_2" which is a sheet and lkupStatus which is a named table.  However, I want both but the interface doesn't allow me to multi-select.  If can't multi-select, what do I need to do at the Power Query interface to go back to the image below?  Thanks very much

[Anonymous · Accepted solution]

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.

[i2rsantos]

I got to this point where I see the Table Range, but no idea how to add this to my data model.  It also looks like I broke the query for importing the data sheet.