Excel Data not transformable

[Alltasks_Chris]

I have 33 Tables in a PowerBI Report, 30 of them are coming from a SQL database and 3 are tables in an Excel file

I want to do a relatively simple transform on 2 of the tables from Excel but they don't appear in the Power Query editor as options and if I write my query with M in a new Blank Query I get errors "The Name '{TableName}' wasn't recognized." is this a limitation of Excel as a data source? I haven't tried this approach before but reading around it sounds like other people are able to transform excel data sources so I'm not sure what I'm missing.

[Vijay_A_Verma]

Make sure those tables are structured tables not ranges. It means that you selected those one by one, pressed CTRL+T to convert them into structured tables.

In Power BI Desktop, under Home tab - Click Excel workbook - Navigate to your Excel workbook and then open it.

Now, all 3 tables will appear.

[Alltasks_Chris · Accepted solution]

Thanks that's not it, but I removed them and re-added them and they appear now - not sure where I went wrong. Thanks for your time.