Left Merge returning null for all records in Dataflow, NOT in Desktop

[vckbx]

I've got a left merge that is returning null for all records in a dataflow. I expect some nulls, but also expect a lot of matches.

When I copy the dataflow directly into Desktop, the left merge returns values as expected.

Merge results in PowerBI Dataflow:

The exact same merge results in PowerBI Desktop:

I've tried converting the "id" field to text with no luck.

I can even see the field I'm trying to expand in the Table cell details window when on the Merge Queries step:

But when I expand, it returns null

[Anonymous]

Hi @vckbx ,

I think it caused by the large dataset in your table, so it displays all null value at the first time. If you sort by id not the RiderId or scroll down the slider, it may show not only blank values.

According to this:

Please filter out RiderId=blank to see if there are other valid values

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vckbx]

It is returning null for all values. When I connect to the dataflow, all values are null.