Paginated reports, linked tables

[Sergiy]

Hi,

I try to find a way to put several tables that use different datasets inside a parent table that has its one dataset.

I have no success.

How this task should be solved?

I need something similar to main/subforms in MS Access:

https://support.microsoft.com/en-us/office/create-a-form-that-contains-a-subform-a-one-to-many-form-...
The main form has to filter data in its subforms.

I found out that if my main and sub tables use the same dataset then filtering is possible. But that is not my case. My tables need to have different datasets. Parent table should filter each of its child tables.

The graphical representation of idea:

 

[Sergiy · Accepted solution]

Sub reports served the purpose.

[v-deddai1-msft]

Hi @Sergiy ,

It seems that your have solved your issue. Would you please mark your reply as answer to help others with the same issue to find it more quickly. And you can find more information about subreport from https://docs.microsoft.com/en-us/power-bi/paginated-reports/subreports#use-parameters-in-subreports

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

Best Regards,

Dedmon Dai