Forum Discussion

smpa01's avatar
smpa01
Community Champion
2 years ago

separate filters different pages

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 fil...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

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

smpa01's avatar
smpa01
Community Champion
2 years ago

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's avatar
    lbendlin
    Super User
    2 years ago

    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's avatar
      smpa01
      Community Champion
      2 years ago

      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}