Forum Discussion

StephenF's avatar
StephenF
Responsive 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
StephenF's avatar
StephenF
Responsive 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
Resolver 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
    Responsive 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
      Resolver III
      7 years ago

      Please click onn table and expand it.

      • StephenF's avatar
        StephenF
        Responsive Resident
        7 years ago

        > Please click onn table and expand it.

         

        This doesnt help me.