Microsoft Certified Power Bi Data Analyst Associate · Free Practice Question Medium
Question 20
You are working on a Power BI report for the sales department. The report uses the following tables, as shown in the image:
The Properties pane for the Product table is open. The storage mode is currently set to Import, but you notice that the Is Featured Table property for the Product table is currently set to No.
You want the Product table to appear as a featured table in Excel for users accessing it via the Analyze in Excel feature.
Which action should you take to set the Product table as a featured table for external use?
-
A
Enable relationships between the Product and SalesOrderDetail tables.
-
B
Enable the "Is Featured Table" option in the Properties pane for the Product table.
-
C
Set the storage mode for the Product table to DirectQuery.
-
D
Configure row-level security (RLS) for the Product table.
Reveal correct answer
Correct answer: B
Explanation
Power BI allows users to designate tables as Featured Tables so that they can be easily accessed in Excel via the Analyze in Excel feature.
How to Enable a Featured Table in Power BI?
Open Power BI Desktop.
Go to Model View and select the Product table.
Open the Properties pane and locate the Is Featured Table option.
Set the option to "Yes" to enable the table as a Featured Table.
Save and publish the report to Power BI Service for use in Analyze in Excel.
For more details, refer to Using Featured Tables in Power BI.
By enabling the "Is Featured Table" option, you ensure that the Product table appears in Excel, making it the best approach for integrating Power BI data with external tools.
A.
Relationships allow data linking between tables but are unrelated to the "Is Featured Table" property.
B.
Setting the Is Featured Table option to "Yes" ensures that the Product table appears as a featured table when accessed in Excel or other external tools using the Analyze in Excel feature.
C.
Storage mode affects how the data is queried (e.g., Import vs. DirectQuery) but does not determine whether the table is featured in Excel.
D.
RLS restricts access to data within the table but does not affect whether the table appears as a featured table in external tools.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
