"Navigate using full hierarchy" option

From a database standpoint, the folders into which the tables and views are organized when this option is enabled are referred to as schemas.  When the option is left blank, the names, such as Production.Product refer to both the schema (Production) and the table (Product), view, or other object type.

You will also notice that when the option is NOT selected, the list is sorted in alphabetical order by object type with Views first, then tables, followed by table valued functions.  If the users are not database people, these terms won't mean anything to them, but can still help them understand when they have to scroll farther if they are using tables and also why the list looks like it is alphabetical, but not completely so.

Hello

There is an option that you can check "Navigate using full hierarchy" under Advanced Options when you go to

Get Data | SQL Server database | Advanced options

What does this do ?

I googled it but found only one related topic (someone said you need to check this when you use stored procedures as a data source with no explanation as to why).

My job is to support Power BI users within the company I work for.

Thanks in advance !

This may be a few years late...But for good measure--here's some documentation from Microsoft