Are columns from an Access database shown in the Navigator window when connected?

Are columns from an Access database shown in the Navigator window when connected?

• A. Yes
• B. No
• C. Only some columns
• D. Only if selected

Answer: (B)

When connecting Power BI to an Access database, the Navigator window allows users to view and select which tables or queries they want to import into their Power BI report. However, while you can see the tables or queries, individual columns from those tables are not explicitly displayed in the Navigator. Instead, you see a structured list of the available data sources, and the specific details, such as individual columns, are revealed after you select a table for import. This design choice emphasizes the focus on tables or queries as the main units of data in Access, as opposed to accessing columns directly at the initial connection stage. Thus, users need to select a table, and only then can they explore its structure and columns within Power BI's data model interface after import.

When connecting Power BI to an Access database, the Navigator window allows users to view and select which tables or queries they want to import into their Power BI report. However, while you can see the tables or queries, individual columns from those tables are not explicitly displayed in the Navigator. Instead, you see a structured list of the available data sources, and the specific details, such as individual columns, are revealed after you select a table for import.

This design choice emphasizes the focus on tables or queries as the main units of data in Access, as opposed to accessing columns directly at the initial connection stage. Thus, users need to select a table, and only then can they explore its structure and columns within Power BI's data model interface after import.