Forum Discussion
Solved
Combining data from two different tables
Hi, I'm currently using Direct Query (and cannot change to import since it needs to be live) and cannot figure out how to get the data to display the way I need it to. I have two tables that are ...
I managed to this to work by starting over. I had added one column to the table, so i'm not sure if that's what was holding this up or what, but i did manage to get this to work.
Thanks for your help!
KWelsh8144,
You can merge the two queries in Power BI Desktop query editor based on ID, for more details, please review this blog:http://radacad.com/append-vs-merge-in-power-bi-and-power-query.
Regards,
Lydia