Forum Discussion

nazdravanul's avatar
nazdravanul
Frequent Visitor
8 years ago

Merge problems - incorrect expand

Hi all,    I have the following problem. I have 2 tables, which have the following approximate format:   Table 1 (selection of columns)   Email           Transaction ID  Date              Payme...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi nazdravanul,

 

Assuming that you have added a index column, then you only need to select Table 1 and click Merge Queries like below.

 

The detail steps you could have a reference of my attachment.

 

Best Regards,

Cherry

nazdravanul's avatar
nazdravanul
Frequent Visitor
8 years ago

Thank you for the reply. I've been using PowerBI for years, I know how to use the UI to do an Expand. That is not my problem. After expand part of the data is incorrectly ported from Table 2 to Table 1 - see details in my post. 

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi  nazdravanul,

     

    I'm not very clear abourt your issue based on your description and I cannot reproduce your issue in my side. Could you share a screenshot about your issue?

     

    If it is convenient, could you share a dummy pbix file which can reproduce this issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

     

    Best Regards,

    Cherry