Forum Discussion
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 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.
5 Replies
You should be able to define and use page specific bookmarks.
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.
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.
