Is it possible to append two user created tables? When I go to Edit Queries, I don't see my user created tables on the left hand side. Assuming because the tables weren't created via query, but via Modeling --> New Table.
I essentially need to join the data of my two new tables created in Power Bi.
Yes, the tables created via "New Table" do not appear in "Edit Queries" window.
Are you talking about union or join tables? To union tables, there's a DAX function UNION. While to JOIN tables, there're functions CROSSJOIN,NATURALINNERJOIN,NATURALLEFTOUTERJOIN. However usually you don't have to use them if proper relationship is created among tables.