Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Load only rows where a value exists...

‎09-22-2020 01:56 PM

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!

Labels:
Message 1 of 4
1,760 Views
0
3 REPLIES 3
v-jayw-msft
Community Support
Community Support

‎09-25-2020 01:06 AM

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

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.
Message 4 of 4
1,684 Views
0
Fowmy
Super User
Super User

‎09-22-2020 02:09 PM

@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

Did I answer your question? Mark my post as a solution! and hit thumbs up


⭕ Subscribe and learn Power BI from these videos

⚪ Website ⚪ LinkedIn ⚪ PBI User Group

Message 3 of 4
1,727 Views
0
darentengmfs
Post Prodigy
Post Prodigy

‎09-22-2020 02:07 PM

@Anonymous 

 

What is your data source?

Message 2 of 4
1,754 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

View All