Forum Discussion

Markzolotoy's avatar
Markzolotoy
Impactful Individual
5 years ago
Solved

Paginated report - nested tables with different datasets

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

Help

3 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    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.

  • AbhiSSRS's avatar
    AbhiSSRS
    Solution Sage
    5 years ago

    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's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    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.