🔥 3-day streak
Microsoft Power BI Data Analyst98 / 205
Question 98 of 205

You are finalizing a star-schema semantic model in Power BI Desktop. The Sales fact table contains a ProductKey column and a CustomerKey column that are used only to define relationships to the Product and Customer dimension tables. Report authors have complained that these numeric key columns clutter the Fields pane and are occasionally dragged into visuals by mistake, producing meaningless aggregations. You must improve the model's usability without breaking the relationships. What should you do?

Reviewed for accuracy · Report an issueNext question