separate filters different pages

[smpa01]

@AlonBAR   in Export to PDF is there any way to utilize different filters for different pages and get one pdf that contains data for page 1 with filters specific to page 1 and data for page 2 with filters specfic to page 2?

I can do this, but it filters the whole report as per the filter mentioned there, how can I apply page specific filters here?

Iif it currently not possible, is it something to be expected in the future?

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

Thank you in advance.

[lbendlin]

You should be able to define and use page specific bookmarks.

[smpa01]

If I have n number of disitnct and dynamic values in a filter for page 1 and f number of distinct and dynamic values in a filter for page 2, one needs to create distinct bookmarks (forEach n and f  X no. of reports- everyday) in order to bring your suggestion to life if any, This is not practical.

[lbendlin]

The Power Automate Export action has no idea what you (the report user) have chosen as your dynamic filters when you interact with the report.  It can only work with the default settings, plus whatever you provide it for guidance. You looking at the webpage, and Power Automate asking for a rendering are two separate processes.

[smpa01]

I probably could not make you understand the req.

This is not a Power Automate task. Currently done in powershell, will be migrated to Fabric.

It is not a user driven-action; it is a developer driven action to export report forEach n numbers of users that end up in report page(s) filters

I am making REST calls to see which are the distinct values in pg1 and pg2 and then calling Export to PDF.  The query already knows the n to apply to filter pg1 and f to apply to filter pg2. If pg1 and pg2 is made from the same datasource (table) as well as n and f are also coming from the same table, then it is fine. But with data-modelling it is often not the case, Hence I want to know if the following is currently possible, if no, is it on the cards?

$requestBody = @"
{
    "format": "PDF",
    "powerBIReportConfiguration": {
        "pages": [
            {
                "pageName": "ReportSection1"
            },
            {
                "pageName": "ReportSection2"
            }
        ],
        "reportLevelFilters": [
           {"filter": "Calendar/Month in ('Jan')"}   /*to be applied to ReportSection1*/,
           {"filter": "dim_Gender/Category in ('Female')"}   /*to be applied to ReportSection2*/
        ]
    }
}
"@@

Worflow => Execute Dax Queries=> {forEach =>ExportToFile->Polling->Get File Of Export To File}

[lbendlin]

"Execute DAX Queries"  is not part of the workflow. The rendering is hidden from you, as part of the "ExportToFile" step.

Export Power BI embedded analytics reports API - Power BI | Microsoft Learn

Currently page level filters (beyond bookmarks)  are not supported

Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41