Load only rows where a value exists...

[Anonymous]

I have two tables, opportunities and accounts.

In opportunities, each row has a value for account ID.  I only want to load rows from the accounts table where the account ID already exists.  In qlik, I would:

Load *

Where exists (account ID)

from xxxxxxx

I'm not sure how to do this in power BI however!

Thanks in advance!

[v-jayw-msft]

Hi @Anonymous ,

Has your problem be solved?

Merge queries feature should help. For more details please check the video.

https://www.youtube.com/watch?v=dTdFt9AvDHA 

Best Regards,

Jay

[Fowmy]

@Anonymous 

You need to use the Merge feature in Power Query to create a left-out comparison and filter the column.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[darentengmfs]

@Anonymous 

What is your data source?