Question

You are building a sales model in Power BI Desktop. During data profiling you notice that the ProductKey column in your Products dimension query is stored as text with leading zeros (for example, '00457'), while the ProductKey in your Sales fact query was auto-detected as a Whole Number (457). You need the relationship between the two tables to work correctly and preserve every product code exactly as delivered by the source. What should you do in Power Query before loading?

Accepted Answer

Change the ProductKey column in the Sales query to the Text data type so both keys use the same type and the leading-zero format is matched.

Answer

Change the ProductKey column in the Products query to Whole Number so both keys are numeric and can join.

Answer

Leave the data types as-is and let the relationship engine implicitly convert the values when the relationship is created.

Answer

Merge the two queries on ProductKey using a fuzzy match to tolerate the formatting difference.