Export to PDF

[smpa01]

I am using ExportToFile API which is amazing to say the least.

How can I specify a page so that it only exports pgName=Pg10 instead of whole report. Also, I nedd to use a Filter .  I tried this in powershell which did not work as desired; it is still exporting the whole report. @AlonBAR  @GilbertQ@frithjof_v 

$reportID ="lorem-ipsum"
$apiEndpoint = "https://api.powerbi.com/v1.0/myorg/"

$requestUrl = $apiEndpoint+"reports"+"/"+$reportID+"/ExportTo"

#also I need to use a filter on pg10 where Calendar[Year] eq 2024
$requestBody = @"
{
	"format": "PDF",
    "pageName":"pg10"
  
}
"@

$response = Invoke-PowerBIRestMethod -Url $requestUrl -Method Post -Body $requestBody -ContentType "application/json" 

Thank you in advance.

[GilbertQ]

Hi @smpa01 

I'm not sure if this is possible to export a single page in a report. What I would do is just to create a new report with the single page, which you could then export.

[smpa01 · Accepted solution]

This is absolutely doable from the report with n number of pages. I have tested out.

Worflow => ExportToFile->Polling->Get File Of Export To File

$requestBody = @"
{
    "format": "PDF",
    "powerBIReportConfiguration": {
        "pages": [
            {
                "pageName": "ReportSection1234567890"
            }
        ],
        "reportLevelFilters": [
           {"filter": "Calendar/Month in ('Jan')"}
        ]
    }
}
"@@