cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Markzolotoy
Impactful Individual
Impactful Individual

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

2 ACCEPTED SOLUTIONS
v-janeyg-msft
Community Support
Community Support

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:

2.png3.png4.png

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.

View solution in original post

v-janeyg-msft
Community Support
Community Support

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.

View solution in original post

3 REPLIES 3
v-janeyg-msft
Community Support
Community Support

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.

View solution in original post

AbhiSSRS
Super User
Super User

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
Community Support
Community Support

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:

2.png3.png4.png

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.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.