Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Original question posted by @actzikas within a wrong thread. This post aims to answer actzikas question:
"Could you bring into two tables as a source?
= Table.SelectColumns(Table 1, {"OwnerId", "Type", "CreatedDate", "Creator_Role__c"})
and somehow have another Table.SelectColumns for Table 2" link to original post
Solved! Go to Solution.
Hi @actzikas ,
I hope I'm interpreting your question, right? From the looks of it you wish to Join or Combine two tables into one query?
As you haven't stated what columns [Table 2] contains or what your output table might look like - I’ll signpost you to a great video by @reza_rad (links below) where he explains the difference between the two types of combining query options available in Power BI; A: "Merge", and B:"Append".
If I may also suggest using the functions already accessible on the Home menu. It is much easier than writing your own "M" script (however, it can be done via the "Table.NestedJoin" function for merge or for append “Table.Combine”.)
Links to more info
Hi @actzikas ,
I hope I'm interpreting your question, right? From the looks of it you wish to Join or Combine two tables into one query?
As you haven't stated what columns [Table 2] contains or what your output table might look like - I’ll signpost you to a great video by @reza_rad (links below) where he explains the difference between the two types of combining query options available in Power BI; A: "Merge", and B:"Append".
If I may also suggest using the functions already accessible on the Home menu. It is much easier than writing your own "M" script (however, it can be done via the "Table.NestedJoin" function for merge or for append “Table.Combine”.)
Links to more info
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
37 | |
31 | |
26 |
User | Count |
---|---|
92 | |
50 | |
44 | |
40 | |
35 |