Forum Discussion

W2SANC's avatar
W2SANC
Icon for Helper II rankHelper II
3 years ago

Merged Column Show Up in Power Query Editor but Columns are Empty in Data Tab & in Data Viz's

Hey!    I recently followed the advice someone gave that worked on adding a column based on another columnn in another table by merging queries (see that post here https://community.fabric.microsof...
Need Help
Tutorial Requests
W2SANC's avatar
W2SANC
Icon for Helper II rankHelper II
3 years ago

Additional information: Backing up to the step where I merged to get the FIPS code added to the main sales table - screenshot is below. Is how I expanded the column (where cells all say "table") what I am doing wrong? 

 

First photo: what is seen after the merge. Second photo: what the options are when I click expand. 

 

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    W2SANC , I doubt your join column values are not matching. can you check that


    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • W2SANC's avatar
      W2SANC
      Icon for Helper II rankHelper II
      3 years ago

      Truly new novice/beginner here, what do you mean by "check that" and I can make up a few small data point shortly in the next reply.