Suggested tables for Excel (and JSON improvements)

This feature shows suggested tables when you load data from an Excel workbook (as shown here) or from a JSON file.

The problem this feature is addressing

Consider this Excel worksheet (feel free to download it to try this out yourself):

The worksheet contains 3 tables, but will Power BI find them?

Here's what Power BI detects by default:

You're going to have your work cut out transforming this data in Query Editor to extract the 3 tables!

A digression: you could solve this with range names

Before I continue, I have to mention that I don't think the new facility is the best way to solve this problem.  It would be much better to assign each table a range name:

Here I'm giving the shopping centres table a range name, for example.

You can then choose these when loading data into Power BI:

You can choose the ranges of data you want to load.

Having got that off my chest, I can now show how the new Excel feature works!

Featured tables in Excel

If you try to load our original messy worksheet, you can choose at the bottom left one or more suggested tables:

However, notice that only two tables have been picked up (for some reason the table of regions hasn't been detected).  Power BI also has no way of naming the tables automatically.