Power query function to expand the first table of a workbook

[webportal]

I have a bunch of Excel workbooks with a table in them.

Some tables have the name "Table1", while some others have another name.

Power Query built a function like:

let
    Source = (Parameter1) => let
        Source = Excel.Workbook(Parameter1, null, true),
        Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data]
    in
        Table1_Table
in
    Source

Which is breaking in the cases where the table has a different name.

How do I adapt this code to get the first table it finds within the workbook irrespective of the name?

Thanks!

[webportal]

@AlienSxthat's it, thank you!

[CNENFRNL]

[webportal]

@AlienSxthanks for helping!

The Excel object contains multiple objects, like sheets, named ranges and tables.

By 1st table, I mean, whatever name it is, I want the first it finds, because I know that each file contains only one.

[AlienSx · Accepted solution]

let
    Source = (Parameter1) => let
        Source = Excel.Workbook(Parameter1, null, true),
        Table1_Table = Table.SelectRows(Source, each ([Kind] = "Table"))[Data]{0}
    in
        Table1_Table
in
    Source

[AlienSx]

Hello, @webportal what is "first table"? Run 

Excel.Workbook(Parameter1, null, true)

with some Parameter1 value. You get the list of items in that workbook. Okay, filter "Kind" column to get tables only. How do pick "first" table? What is it?