Data Source Spreadsheet, Navigator displays Tabs vs Tables

[dd88]

I connect the PowerBi report to the data source an Excel file.

In Navigator
The top, displays all tabs in the Excel spreadsheet

The bottom, displays Suggested Tables

With tabs I would need to clean up, as the columns have default names ie Column 1, Column 2, and clean up the data area

I would like to use the Suggested Tables as it has the correct column names, and the correct data

I created new Excel tabs in the spreadsheet, which display at the bottom of tabs, however the new tabs do not display or get picked up in Suggested Tables.

Tables - Is this an automatic function in power bi.
I am wondering how to get the new tabs to dsiplay as suggested tables. I can manually Insert, Create and Name the tables.

However I did not do this with the orginial Suggested Tables.

any ideas.

if I need to create/setup the tables manually so be it ..

TIA

[dd88]

Thank you @Shosher  and @mickey64 

All tabs are created from a 'template' and have the same columns, layout etc.  A tab is a for a specific department eg finance, HR, administration etc

For now I think I will manually create/ format a table in each tab

Thank you again ..

[Shosher]

In my opinion loading pages and cleaning up is the best. As long as every new page has the exact same layout you could load all pages within a group everytime the report loads. If you need a quick and easy fix and setting the new sheets as a table is not something you'll be doing an hour every week for the next 10 years it can be a valid solution. preferably however you'd automate it. 

preferably if its a version control which archive makes it seem like it is you would save those as seperate excell files. In that way you can load in a folder, do the nessecary steps to clean for each file and merge them. This works lovely and is probably your cleanest answer. Im not sure if that is possible within one excell file but im sure its possible across multiple files.

The very very best scenario is avoiding either and getting a dataconnection straight to the source of the excell data. unless this is completely  manual entry in which case you'll still end up doing the exact same. 

[mickey64]

Step 0: I use a data sheet below.

Step 1: I select whole table data on Excel.

Step 2: I click 'Format as Table' and select a format.

Step 3: I can change the name of the table.

Format an Excel table - Microsoft Support