Forum Discussion

rohithkothaneth's avatar
rohithkothaneth
Icon for Resolver I rankResolver I
2 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.

rohithkothaneth's avatar
rohithkothaneth
Icon for Resolver I rankResolver I
2 years ago

What I mean by URL is the power BI service URL after passing filter values within the URL header.
I did tried to passed in the rpeort filter section at the time of "Exporting a PBI report" but Power automate couldnt apply those column value back into the power Bi report into the slicer section to refresh the visual in the report pages.