Forum Discussion

rohithkothaneth's avatar
rohithkothaneth
Icon for Resolver I rankResolver I
3 years ago
Solved

Dynamically export the report pages to PDF based on slicer value which is driving a Power Bi report

Hello,   I have a Power BI desktop report which is driven based on a column value "Client name" within a "Customer" table. Here the same column value is used as a slicer to populate visuals in the ...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    It works for me - check your data model and your table and column spelling.  As you mentioned you can use the report URL for checking that it filters correctly. 

  • rohithkothaneth's avatar
    rohithkothaneth
    2 years ago

    It was not working because, i had set the slicer to have a mandatory "Single selection" turned ON. Once I remove that, I was able to successfully test this by passing filter value as  a header in the URL. Same was dynamically generated in Power automate flow and passed within the filter parameter section for the "Exporting a PDF of the PBI report" connector in Power autiomate.

     

    https://app.powerbi.com/groups/******/reports/******/ReportSection*****?filter=<Table name>/<column name> eq '<column value>'

    Thank you for confirming that this solution works.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago

Add your filter column to the Power Automate visual and then use that data to specify the export filters in Power Automate.

  • rohithkothaneth's avatar
    rohithkothaneth
    Icon for Resolver I rankResolver I
    3 years ago

    Thank you lbendlin for your response.
    when I add the filetre column to my power automate visual, i can use the value inside the power automate, but when i want the same filter values to go through a loop and apply back to report so thet visuals in the pages changes accordingly for me to export is where it is not working. Every time I loop through the list and try to apply different value to generate the visual and when tried to export the report into a PDF, the report output comes with the default selection and doesnt gets changes based on the filter value that i apply through power automate.

    Attached my flow that I cerated  for your reference.

    Thanks,
    RohithPower automate flow - 1Power automate flow - 2Power automate flow - 3

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      3 years ago

      You didn't apply the report level filter(s).

      • rohithkothaneth's avatar
        rohithkothaneth
        Icon for Resolver I rankResolver I
        3 years ago

        My report page visuals are driven by the slicer value which is also based on the same column that i have passed to the power automate. I tried to pass the value as a filter in the URL, but the slicer doesnt get chnaged. It needed be picked manually to get ti changed. Is there a way for me to interact with the slicers via any means.
        I tried addinga report filter but the slicer didnt get changed.