Question 490
In a Microsoft Power BI project, A transaction ID arrives as text '00009218' and must preserve leading zeros for reconciliation. Choose the most defensible solution.
Explanation
Correct Answer
This directly addresses the stated constraint. Identifiers are labels even when their characters happen to be digits. Confirmation: The value remains '00009218' across refresh and joins to the source key.
Incorrect Answers
Choosing DirectQuery over a separate SQL endpoint misses the requested DirectLake path. The specific problem here is that changing the identifier to Whole Number discards its leading zeros.
Deleting the broken rename step without checking downstream references can corrupt measures. The specific problem here is that changing the identifier to Whole Number discards its leading zeros.
Unpivoting MetricName would increase the row-level representation instead of creating metric columns. The specific problem here is that changing the identifier to Whole Number discards its leading zeros.