Forum Discussion

vckbx's avatar
vckbx
Icon for Helper I rankHelper I
4 years ago

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

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

 

 

Data Protection

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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's avatar
      vckbx
      Icon for Helper I rankHelper I
      4 years ago

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