Paginated report - nested tables with different datasets

[Markzolotoy]

I need to have a table in a cell of another table because second table is a details table. The details are coming from a different dataset. Is it possible to make it work without putting all the data together?

Thanks

[v-janeyg-msft · Accepted solution]

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 | Micr...  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.

[v-janeyg-msft · Accepted solution]

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.

[AbhiSSRS]

Hi!

Unfortunately you can work only with single dataset for a group in a tablix, you may though use lookup to get values from another dataset. If you can provide more details on your datasets and end Visual targeted sketch then maybe could suggest something !

[v-janeyg-msft · Accepted solution]

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 | Micr...  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.