HOTSPOT
-
You are using Power BI Desktop to connect to an Azure SQL database.
The connection is configured as shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct solution is worth one point.
10min Only tables with data If navigate using full hierarchy is unchecked you can see only tables(rows n columns) with data. Otherwise you can see all tables
If you only follow the documentation from Microsoft, it is open to interpretation unless you stepped through the process. I cannot add a screenshot in this post but use the this link to use as a reference on how exactly the Navigator would look like using with the "Navigate using full hierarchy" is checked and unchecked. I connected to an Azure SQL Database with tables containing data and others are blank. Marking the "Navigate using full hierarchy" will list the Schemas first and the hierarchy for each object under each schema (e.g. dbo, db_onwer, etc.). Unmarking the "Navigate using full hierarchy" will show all the tables whether with data or without data.
Sorry, I forgot to add the link for the screenshot. https://community.fabric.microsoft.com/t5/Desktop/quot-Navigate-using-full-hierarchy-quot-option/m-p/375700
doesn't have sc or related info
The defaut time out is 10 minutes, but if it takes more than it you can enter another value in minutes to keep the connection open longer. 1. 10 minutes 2. All the tables Reference: https://learn.microsoft.com/en-us/power-query/connectors/azuresqldatabase
Navigate using full hierarchy is unchecked. Only table with data will be displayed.
Only tables with data. From your reference link, under Connect using advanced options, it clearly shows that "Navigate using full hierarchy If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data."
True, I have seen it
it says in your reference link for "Navigate using full hierarchy" : If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data. Which means, it'll only show the tables with data and not all tables.
Wrong, as per Microsoft-> If cleared, the navigator displays only the tables whose columns and rows contain data (copied from MS)
Answer is correct: 10 minutes (default) Only tables with Data Navigate using full hierarchy: If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data. https://learn.microsoft.com/en-us/power-query/connectors/azure-sql-database
Please ignore my first answer, after reviewing in detail Correct answer is 10 Minutes and Only Table with Data If "Navigate using full hierarchy" is unchecked in the Fields pane in Power BI Desktop, then only the tables and fields that contain data will be displayed in the report view. Any tables or fields that do not have data will be hidden from view. However, it's important to note that this option controls the behavior of the Fields pane in the report view, and does not affect the data that is loaded into the report. Even if the option is unchecked, all tables and fields in the data model will still be available for use in the report. They just won't be visible in the Fields pane unless they contain data. So, if you want to ensure that only the tables and fields with data are shown in the report view, you can uncheck "Navigate using full hierarchy" in the Fields pane. But if you want to include all tables and fields in the data model, even if they don't currently contain data, you should leave the option checked.
The solution is correct. 10 minutes default timeout Only tables that contain data reference to https://learn.microsoft.com/en-us/power-query/connectors/azure-sql-database
Correct!: Command timeout in minutes: If your connection lasts longer than 10 minutes (the default timeout), you can enter another value in minutes to keep the connection open longer. This option is only available in Power Query Desktop. Navigate using full hierarchy: If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data. Include relationship columns: If checked, includes columns that might have relationships to other tables. If this box is cleared, you won’t see those columns. https://learn.microsoft.com/en-us/power-query/connectors/azure-sql-database
Yes answer is 10 min , only tables with data as this is azure sql server not on premises sql server https://learn.microsoft.com/en-us/power-query/connectors/azure-sql-database
10 Min. All Tables. I work with DirectQuery in my job.
and what does fialeover do?
The correct answers are: ** 10 minutes . The default timeout for the connection from Power BI Desktop to Azure SQL database is 10 minutes. ** All the tables : the navigator will display all the tables available in the specified database, regardless of whether they contain data or hierarchies.
Not according to this: https://learn.microsoft.com/en-us/power-query/connectors/azure-sql-database#connect-using-advanced-options Check the Navigate using full hierarchy entry in the box.
Is the answer ALL Tables or Only tables that contain data? I think the real confusing is there?
correct answer
10 MINUTES ONLY TABLES WITH DATA
So, if you want to ensure that only the tables and fields with data are shown in the report view, you can uncheck "Navigate using full hierarchy" in the Fields pane. But if you want to include all tables and fields in the data model, even if they don't currently contain data, you should leave the option checked.
Navigate using full hierarchy If checked, the navigator displays the complete hierarchy of tables in the database you're connecting to. If cleared, the navigator displays only the tables whose columns and rows contain data.
Include relationship columns If checked, includes columns that might have relationships to other tables. If this box is cleared, you won’t see those columns.
Correct Answer 10 Minutes and All tables The Navigator window in Power BI will display all tables available in the data source, regardless of whether or not they contain data. However, when you preview the data in the Navigator window, only the tables that have data will display data in the preview. When you connect to a data source in Power BI, the Navigator window will typically display a list of tables, views, and other objects available in the data source. This list may include tables that are empty or have no data. No confusion, and no need to further discuss
I would say there is a need to further discuss it. The documentation about Azure SQL database states that if full hierarchies is unchecked, 'the navigator displays only the tables whose columns and rows contain data', as others have already stated and linked to. What you describe is my experience with Microsoft SQL Server as well, but Azure SQL database appears to be an exception.
I think the real confusion is, should you answer what the documentation tells you or should you answer based on experience (because some have apparently tested it and agree with you) :)
10 MIN Only tables with data