Forum Discussion

StephenF's avatar
StephenF
Icon for Responsive Resident rankResponsive Resident
7 years ago

Cannot expand merged query (?)

I've got 2 tables and i "merge to new" one with the other via a common column with a left outer join thats many to one.   I get my first table, now with a column at the end with the word 'table' in...
Need Help
hthota's avatar
hthota
Icon for Resolver III rankResolver III
7 years ago

Please click on the merged query column at top you can see the columns present in the second table and click on expand. It would work and help you.

StephenF's avatar
StephenF
Icon for Responsive Resident rankResponsive Resident
7 years ago

As I said there no option to expand here. I normally expect an icon in the column header that looks like two angle brackets back to back. It is not present.

  • hthota's avatar
    hthota
    Icon for Resolver III rankResolver III
    7 years ago

    Could you please share you query and screen.

     

    Please check it once you updated you power bi Desktop app.

     

    Thanks,

    Hemanth Thota.

    • StephenF's avatar
      StephenF
      Icon for Responsive Resident rankResponsive Resident
      7 years ago

       

       

       

       

       

       

       

       

       

       

       

       

      Query:

      #"Merged Queries" = Table.NestedJoin(#"Replaced Value5", {"BRN"}, #"BRN Data", {"BROADCASTER_REF"}, "BRN Data", JoinKind.LeftOuter)
      in
      #"Merged Queries"

      • hthota's avatar
        hthota
        Icon for Resolver III rankResolver III
        7 years ago

        Please click onn table and expand it.