PL-300 Question 62

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• 1

  To make Business Unit available as an organizational data type in Excel, configure the table properties in Model view as follows: - Is featured table: Yes - Key column: ID (must uniquely identify each row) - Row label: Name (the friendly display value users will see in Excel) These settings expose the table as an organizational data type and ensure users see readable names while Excel uses the unique ID behind the scenes.

• 1

  Row Label: Name Key column: ID Is featured Table: Yes Row Label: Name — This makes the table easy to read and understand for users, showing the friendly, descriptive name. Key Column: ID — This uniquely identifies each row internally and supports relationships without cluttering the display. Is Featured Table: Yes — Marks the table as available for Excel organizational data types and Power BI usage.

• 1

  Among the options — Cost center, Headcount, id, and name — Name is the ideal choice for the row label in a featured table in Power BI. It’s readable, intuitive, and helps users easily recognize each record when browsing the data type in Excel. Meanwhile, ID is the best fit for the key column. It’s unique, consistent, and well-suited for identifying each row unambiguously behind the scenes, especially when connecting or refreshing data. Is featured table: yes