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,
What version of Power BI Desktop do you use? Do you merge into a new query using the highlighted option below? If so, switch to use merge queries option. If the issue still persists, please share the T-sql you use to create the two tables so that I can test.
Regards,
Lydia