Filter Dataset using parent table

[sovereignauto]

Good Morning, 

I am new to PowerBi and am linking to a SQL Server.

I have created but the data is 15 years old so there is a lot of it and a lot of related tables.

What im hoping to do is restrict the dataset by putting a date filter on the "parent" table (which i have done already) but then restrict the "child/releated" tables to those that link to the records that are present in the parent data set. 

Example:

Table 1:

Ref

Date

Client 

Table 2 

Ref 

Client name 

Client address 

and so on.... 

I the above situation i only want to bring through clients that are related to table 1

Thank you in Advanced! 

[selimovd]

Hey @sovereignauto ,

you can use an inner join in Power Query.

This should limit the data to the rows that exist in both tables:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[sovereignauto]

Have just found that screen before you posted, Does merge create one table containing all the data or just inner join them? 

Thank you!

[v-janeyg-msft]

Hi, @sovereignauto 

You can choose to operate on the original table or generate a new table when use 'merge'.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sovereignauto]

thank you @v-janeyg-msft 

When i Merge and pair the tables as a left join as not all records in parent are in the second table, on load to apply the changes it still loads all the records (that dont match from the first) 

Parent Table - 80k Records

Child Table - 400K records and counting 

After first sync will it then dump the rest?

[v-janeyg-msft · Accepted solution]

Hi, @sovereignauto 

You can use inner join, merge as new, then cancel the enable load button in original tables.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.