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.

banashree's avatar
banashree
Frequent Visitor
2 years ago

akhilduvvuru I've the filters too and similar situation but not able to extract PDF. How were you able to extract the PDF for 1 customer? Could you please share with me your flow? 

Many thanks

Banashree

akhilduvvuru's avatar
akhilduvvuru
Icon for Helper IV rankHelper IV
2 years ago

banashree - Please check my post. This will work for both 1 or more customers selection.

 

  • banashree's avatar
    banashree
    Frequent Visitor
    2 years ago

    I have the names and email ids in another excel file. I want power automate to pick up each name from the excel and filter the page, extract the pdf and send the pdf via email. The email id is present as a 2nd column in the excel file. How can i instruct power automate to do that?