Microsoft Fabric Data Engineer Associate DP-700 Practice Question

The refresh fails because Power Query attempts to convert every value in the column to the Decimal type, and the text value "N/A" cannot be cast. The most reliable fix is to let the column arrive as Text in the source step, then explicitly convert it to Decimal in a later step while adding a Replace Errors transformation (for example, replacing errors with null). This ensures that any non-numeric values such as "N/A" are gracefully handled and the refresh completes. Simply enabling schema-drift tolerance does not alter the type conversion logic, so the same error will occur. Adjusting parallelism or timeout settings addresses performance or duration problems, not data-type conversion errors.