Overwriting Filter values of power BI report using power automate

[Jessica_17]

Hello All,

I Require one urgent help and I fully new to power automate,

I have a report in power BI , where there is a slicer of Date as "from and to", where default value selected is 23-05-2025, and on top of that we have created flows to export the report into pdf format. Now the requirement is that the date value by default should be latest date and the exported pdf report should be based on that latest date, while apply method like this:-

[
{
"name": "Date",
"type": "Categorical",
"operator": "In",
"values": ["@{utcNow('yyyy-MM-dd')}"],
"filterType": 1
}
]

to overwrite slicer value, it is not working at all, can anyone provide me a solution for the requirement, let me know if we need to change anything in pbix too?

or want the export of last 12 hours of data's dashboard's pdf irrespective of an slicer deafult value is there.

and also this link was not that much helpful:- https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters

Thanks

[Anonymous]

Hi @Jessica_17 ,
I wanted to follow up on our previous suggestions regarding ovewriting filter values. We would like to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

[andrewsommer]

Instead of trying to export the report try using Power Automate to query the semantic model the report is built from. 

Check out this blog post from Matthew Devaney:
Power Automate Run A Query Against A Power BI Dataset

[Jessica_17]

Hi @andrewsommer 

Thanks for the reply, but the user wants the pdf version of the report according to the latest date, so it has some other designs as well which needs to be added in it, can we some different approach for this?

[Anonymous · Accepted solution]

Hi @Jessica_17 ,
Thank you @andrewsommer  for the helpful insights!

Thanks for the follow-up! Since slicers can not be controlled directly from Power Automate, the best way is to use report level filters in your flow export action. You may dynamically filter by today’s date or last 12 hours using expressions like utcNow(). This ensures the exported PDF always reflects the latest data, without needing changes in the PBIX file.
Thank you.

Regards,
Pallavi.

[Jessica_17]

HI @Anonymous 

Thanks for the solution, I tried it , and it worked for me, thanks.