Multiple Choice Difficult

QWhat will happen if a Sales table has no relationship with a Product table, and a report attempts to display Product Name and Total Sales together?

ID: #25388 Introduction to Power BI 2 views
Question Info
#25388Q ID
DifficultDifficulty
Introduction to Power BITopic

Select All That Apply

Tick every correct option, then press Check Answer.

  • A Power BI automatically creates the relationship.
  • B The report will always show accurate results.
  • C The dataset refresh will fail immediately.
  • D The report may show incorrect or unrelated results because the tables are not connected.
Correct Answer

Explanation

Option D is correct because without a relationship, Power BI cannot properly associate sales records with products. This often leads to incorrect aggregations, duplicated values, or meaningless results. Option A is incorrect because Power BI does not always create relationships automatically. Option B is incorrect because accurate results require proper relationships. Option C is incorrect because missing relationships do not necessarily cause refresh failures.

Share This Question

Challenge a friend or share with your study group.