Paginated Report: Append Reports based on multi-valued parameter.

[useetharam]

I have a report with mutiple tablix in it detailing Sales and purchase details. The requirement is to run the report for mutiple Items and the report output should be appended one after another.

The ITEM2 data should not be present in the same table as ITEM1. A new page/report should get generated for 2nd Item and so on.

Sample output shown below:

PAGE1: ITEM1

ITEM1
Sales History		JAN	FEB	MAR
QTY		100	200	300
Purchase Order
ITEM1			QTY
	PO1		110
	PO2		200
	PO3		50

PAGE2: ITEM2

ITEM2
Sales History		JAN	FEB	MAR
QTY		100	200	300
Purchase Order
ITEM2			QTY
	PO1		110
	PO2		200
	PO3		50

[v-yueyunzh-msft]

Hi , @useetharam 

As far as I know, the paginated report in PBI can only pursue a more perfect matching effect of pixels when printing or exporting, but there is no function to automatically generate new pages/reports, for similar needs we can give advice is to go to Power Query to append query the original table in the data model to generate a full data table in the table or matrix placed in your paginated report:

Append queries - Power Query | Microsoft Learn

Best Regards,

Aniya Zhang

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