Paginated report - nested tables with different datasets

Hi, Markzolotoy 

This tutorial can solve your problem very well: Create a paginated report with a Power BI shared dataset - Power BI Report Builder - Power BI | Microsoft Docs  You can refer to it patiently.

According to your description, You need to create the relationship in desktop and create a summarize table,then copy the query to report builder.

Like this:

Reference:SUMMARIZECOLUMNS function (DAX) - DAX | Microsoft Docs

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.

Hi, Markzolotoy 

Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense.

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.