Ignoring Spaces in Inner Join Fabric Dataflow
You have a Fabric workspace named Workspace1 and an Azure SQL database. You plan to create a dataflow that will read data from the database, and then transform the data by performing an inner join. You need to ignore spaces in the values when performing the inner join. The solution must minimize development effort. What should you do?
Community Votes
100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.
Community Insight
The question tests the difference between Merge (join) and Append (union) in Power Query, and the specific fuzzy matching feature to ignore whitespace during a join.
When performing an inner join in a Microsoft Fabric dataflow that needs to ignore spaces in values, you should merge the queries using fuzzy matching. This page establishes that fuzzy matching minimizes development effort by automatically handling whitespace discrepancies without manual preprocessing.
Choosing 'Append' instead of 'Merge' because users confuse union operations with joins, or choosing a lookup table which requires manual trimming logic and increases development effort.
Community Discussion (5 comments)
Comments & Corrections
No comments yet — spotted an error or have a note? Share it below.
Expert Analysis
Why the Answer Is Correct
To perform an inner join in a Power Query dataflow, you must use the "Merge queries" operation. By enabling fuzzy matching during the merge, you can configure the join to ignore whitespace (spaces) in the matching columns, which directly satisfies the requirement while minimizing development effort. This built-in feature avoids the need to add custom transformation steps to trim spaces before joining.Why the Other Options Are Wrong
Options A and C are incorrect because "Append queries" performs a union (stacking rows vertically) rather than a join, so it cannot be used for an inner join. Option D is incorrect because merging with a standard lookup table does not natively ignore spaces; you would have to manually add steps to trim spaces, which violates the requirement to minimize development effort.Community Comment Notes
Commenters correctly pointed out that "Merge = join" and "Append = union", making Merge the only viable option for an inner join. As one user noted, "Fuzzy matching allows you to match data even when there are minor differences, such as extra spaces," which eliminates manual preprocessing. Another user provided the official documentation links forTable.FuzzyJoin and fuzzy match merges to support this functionality. Official Reference
Exam Strategy
Remember that "Merge" equates to SQL JOINs and "Append" equates to SQL UNION. When a question asks to ignore minor differences like spaces or casing during a join with minimal effort, look for the fuzzy matching option in a Merge operation.
Related Analysis
Practice All DP-600 Questions
Access 115 questions with complete answers and detailed explanations.
View Full DP-600 Practice Test →