Forum Discussion

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

Lookup doesn't show data in some rows

Hello everyone. I've a model that shows the tailor made products that I need to manufacture for the costumer. For this I've 2 tables, WORK_ORDR_TRNS (aka WOT) and LGSTC_TRNS_TIME (aka LTT). The fi...
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Yonatan1984 ,

By my test, haven't reproduced your problem, could you please share the error sample? It helps resolve issue faster.

Best Regards,
Community Support Team _ kalyj

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

Hi v-yanjiang-msft 

I share all the the sample.

I don't get any error, only blank data.

  • ValtteriN's avatar
    ValtteriN
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi,

    One useful test that I do in situations like this is to apply "clean" and "trim" steps in powerquery. It is possible there is a space or somethin like that messing with the lookup. Another thing to look out for would be the date format. Date columns data tyoes are typically the most vunerable.

    • Yonatan1984's avatar
      Yonatan1984
      Icon for Helper I rankHelper I
      4 years ago

      Hi ValtteriN 

      The clean and trim dose'nt work.

      Also the date format is equel in all table.