filter and create relationships before loading data

Hi Rjesak ,

Do you have mean you want to create two tables in power bi finally?

The problem is that you want to limit the parent table and limit the supported table(based on parent table), right?

And your query get one table with all duplicated records after using the "parent" limitation.

If yes, I think you can create the parent table by:

select xxx

from parent_table

where limitation

and for support table:

select xx

from support table

inner join parent_table

where parent_limitation

If I'm wrong, please show me what you want more clearly, if you have sample data that will be better.

Thanks.

Aiolos Zhao