Page scaling options for PDF export of paginated reports?

[Anonymous]

Looking for insight on this subject:

Are there any page scaling options available to paginated reports that are similar to the settings available in Excel (Fit Sheet on One Page or Fit All Columns/Rows on One Page) when converting to PDF via print options?

I am transferring multiple sheets of an excel file into a single paginated report that can be exported into PDF from Power BI Service. The paginated report contains multiple tablix matrixes (one for each sheet of the excel report) and varies in it's dimensions.  While the Report Builder properties allow a hard page size to be set, the result is a uniform page size and I need it to change so that it accounts for the varrying size of each tablix matrix. 

The only workaround I've found is to export the paginated report to excel and use the scaling options within the printer settings to scale each sheet accordingly. Are there any settings available that can accomplish this in Service? I would like to remove the extra steps needed for my users to retrieve the PDF in it's desired format. 

[AbhiSSRS]

Hi! This is not achievable with only Report Builder, We used a .net app with Aspose / Open XML SDK to pick generated files from a folder and do these settings programatically on the excel reports generated. That works well but only issue is you need to code for and host a .net app on the server too.

[Anonymous]

Hi @Anonymous ,

You can click "Run" to render the report and set the proper zoom level just like below screenshot:

Best Regards

[Anonymous]

Hi @Anonymous 

Thank you for your response. Unfortunately, that setting does not provide the solution I need as this is a zoom property where I am looking for scaling. Setting the zoom to 25% will still result in tablix columns/rows that spill into another page.

I am specifically looking for a scaling property that is similar to excel's print options (shown below)

[Anonymous]

Hi @Anonymous ,

Sorry that these options you mentioned are not currently available in Report Builder after my investigation...

Best Regards