cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
diegoadum Regular Visitor
Regular Visitor

Read record based on union with an existing table

 Hi,

 

we want to read only records from the table 2 where exists on the related field from table 1 (already loaded)

 

Is there any easy way to do that?

 

Thanks!

 
 
1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Read record based on union with an existing table

in power query editor, use merge, join 2nd table to 1st table and chooise Join Kind to inner and it will give only rows in 2nd table which matches with 1st.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





3 REPLIES 3
Super User
Super User

Re: Read record based on union with an existing table

can you explain bit more what you mean by record from table 2 where exists? can be done in many ways, little more detail will help to provide the solution






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





diegoadum Regular Visitor
Regular Visitor

Re: Read record based on union with an existing table

I have a table already loaded, so the second table has a lot of records that are not related to the filter we did in the first table. Therefore, we want to read only those records which have matched over the existing records from the table 1. So, in others technologies, we used to use the where exist clause to achieve this. But I'm not sure how to to do it in PowerBi.

 
Super User
Super User

Re: Read record based on union with an existing table

in power query editor, use merge, join 2nd table to 1st table and chooise Join Kind to inner and it will give only rows in 2nd table which matches with 1st.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos Smiley Happy
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 122 members 1,792 guests
Please welcome our newest community members: