Exporting PBI report to pdf via Automate Service - slicer selections not taking effect

[kronites123]

Hello:

I have a simple PBI report that has State, Region and 'Call Drop Rates' - I added 2 slicers - one for State and and the other for Region - I am trying to email the grid as a PDF - with State, Region and Rate - based on the slicer selection - by adding a Report Level Filter to the Export step in the flow - but the resulting PDF is not filtered - it just sends the entire report each time. My report level filter is a string variable defined as :

AtRisk/State in (@{variables('var_FinalState')}) and AtRisk/Region in (@{variables('var_FinalRegion')})

In the flow results I see that my variable has the correct selections being passed as input to the Export Step:

[

  {

    "filter": "AtRisk/State in (Maryland) and AtRisk/Region in  ('MD 1 - Statewide')"

  }

]

But the final export completely ignores this and sends the entire report without any filters.

Any suggestions on what I may be doing wrong?

Thanks

Kronite!

[KiranHosakote]

Hi @kronites123 

Yes you can export to PDF with multiple filters and slicers applied, with a Power BI Pro license - See https://medium.com/bi-helper/automated-distribution-of-power-bi-reports-and-dashboards-25fde6c68af0.

For dynamic selection of slicers and filters at runtime, take a look at this option with Power Automate + Power BI Pro. https://medium.com/bi-helper/burst-your-power-bi-reports-838ab593f7bc

[lbendlin]

Text needs to be delimited by single quotes.

Filter a report using query string parameters in the URL - Power BI | Microsoft Docs

Double check the spelling of table and column names.