Print Only the First Page of a Paginated Report - Report Builder OR Power Flow

[jarthda27]

I just can't find a way to eliminate a pesky 2nd blank page in Report Builder or Power Flow......

I've gone through the math and it's right: 

Printable area = Report Height - (Top + Bottom Margin) - Header Height.
I have my report body set to just under the printable area with a Tablix Height less than Printable Area / 3.
My Tablix ALWAYS has three records, and the report is always one page.

But it continues to render the 2nd page.

The first page prints perfectly.  It looks gorgeous.

I've tried to do this in the flow which renders the .rdl and in the .rdl iteself.

[v-jtian-msft · Accepted solution]

Hi,@jarthda27 .I am glad to help you.
According to your description, you have a problem with creating a json configuration using Power Automate to implement the printing of the first page of a paginated report, although in the json code you can see that:

"paginatedReportConfiguration": {
"formatSettings": {
"StartPage": "1",
"EndPage": "1"
     }
}

Printing the start page and end page are both the first page, but it still accidentally prints a second blank page.
This is very strange.
In fact, I think your json code is fine, it works fine, the only flaw is that it prints the second page unexpectedly, you can try to change the parameter for the number of pages to print, for example, try to print three (or more) pages of the report, and see if it can be executed correctly (the above test is for checking the json code)
Although I am not very good at writing json code, I still want to help you.
As it relates to Power Automate, if you think there is a problem with your code, you can also go to this forum to get help, they can make more constructive comments on Power Automate .
URL:Microsoft Power Platform Community Forum Thread

Going back to the problem you are having itself, sometimes printing not as expected can be related to the layout settings of the paged report itself. Incorrect page layout settings are
a common cause of paging reports printing with blank pages (I think you need to focus on checking the layout formatting of your paging report).

You can check your layout in the following directions:

1. Check the report margins and page settings:
Make sure that the width and height of the report are set correctly and do not extend beyond the printable area of the page.
Check your report's margin settings to make sure they don't cause content to overflow onto a second page.

2. Resize Tablix:
Make sure the height and width of the Tablix are within the printable area.
Try setting the height of the Tablix smaller to see if you can eliminate the margins on the second page.

3. Check the header and footer:
Make sure the height of the header and footer does not cause content to spill over onto the second page.
If the header or footer contains large images or text, try reducing their size.

In the Power Automate process, ensure that the correct page ranges are set (StartPage and EndPage are both set to 1).
You have already accomplished this step, but try changing the parameters to see if the same problem occurs when printing multiple pages.
Make sure that there are no other steps or settings in the process that will cause a second page to be generated.
Try to adjust the report content:
You need to make sure that the content of the report does not exceed the printable area of the first page. Try reducing the content in the report or adjusting the layout to fit on one page.

Luckily, I found some documentation and examples of incorrectly formatted paginated reports that resulted in blank pages that I hope you find helpful.

URL:
Avoid blank pages when printing paginated reports - Power BI | Microsoft Learn
SSRS Blank Page Between Pages: Causes and Solutions (hatchjs.com)
Solved: Power BI Report Builder - Many Blank Pages - Microsoft Fabric Community

Please scrutinize the page layout to find out the unnecessary layout settings and modify it.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jarthda27]

Your article about avoiding blank pages did the trick.  Not sure if anyone would have caught it with my description.  My report boday was sized to anticipate the tablix's three records. The doc says don't do that; keep the page size to just the tablix

[jarthda27]

Here is my Print Paginated Report Flow Task with Formatting set to PDF with start page of 1 and 3nd page of 1.  It sill prints the 2nd page.   

{
  "type": "OpenApiConnection",
  "inputs": {
    "parameters": {
      "groupid": "7f374963-9c5d-4440-9aa9-c08dd63c426a",
      "reportid": "d2142ae7-d668-43c4-9d70-35241d0d0d70",
      "ExportPayloadPaginatedReport/format": "PDF",
      "ExportPayloadPaginatedReport/paginatedReportConfiguration/formatSettings": {
        "format": "PDF",
        "paginatedReportConfiguration": {
          "formatSettings": {
            "StartPage": "1",
            "EndPage": "1"
          }
        }
      },
      "ExportPayloadPaginatedReport/paginatedReportConfiguration/parameterValues": [
        {
          "name": "guid_session",
          "value": "@body('Get_a_row_of_header')?['crf8f_sessionplanid']"
        }
      ]
    },
    "host": {
      "apiId": "/providers/Microsoft.PowerApps/apis/shared_powerbi",
      "connection": "shared_powerbi",
      "operationId": "InitiateExportToFileForPaginatedReports"
    }
  },
  "runAfter": {
    "Insert_Card": [
      "Succeeded"
    ]
  },
  "metadata": {
    "operationMetadataId": "995edd32-efb1-4b1b-a681-fee38b9f34bb"
  }
}