Forum Discussion

lenkanovy's avatar
lenkanovy
Frequent Visitor
7 months ago
Solved

Expanding table in Power Query - preview shows correct value, but after expanding its incorrect

Dear comunity,  I'm merging two tables to get data into first table. When I merge the two tables and click into new column to see preview of which row was mapped to the row, it shows correct value...
Need Help
  • lbendlin's avatar
    lbendlin
    7 months ago

    Your code seems rather complex.  Can you strip away anything that is not relevant to the issue?

     

    Have you considered using lookups via Table.AddColumn  instead of merges?

v-achippa's avatar
v-achippa
Community Support
7 months ago

Hi lenkanovy,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you lbendlin and Omid_Motamedise for the prompt response. 

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the response provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Community Support
7 months ago

Hi @lenkanovy,

 

We wanted to kindly follow up to check if the response provided by the user's for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa