Forum Discussion
Responsive ResidentCannot 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 every entry. Theres no option to expand here within the column header as I would expect.
What can i do to get the columns out of the second table into my first table.
I've done this before and had no problems with other data sets.
9 Replies
hthotaResolver III
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
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
Could you please share you query and screen.
Please check it once you updated you power bi Desktop app.
Thanks,
Hemanth Thota.
