Forum Discussion

rkaganov's avatar
rkaganov
Regular Visitor
2 years ago

Programmatically export individual user PDF reports from Power BI with Power Automate

I have a Power BI report displaying disk usage data with various visualizations. It includes: A slicer for filtering by user ID A table showing disk usage details per user (paths, sizes) My goal...
Need Help
rkaganov's avatar
rkaganov
Regular Visitor
2 years ago

Hi Ibendlin,

  1. Considering my scenario, could you outline the most suitable approach using Power Automate web modules and connectors?
  2. Which specific modules would be involved in each step of the process?

Thanks
 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    There is only one action for that.

     

    Personally I cannot recommend doing that. I don't think Power Automate is robust enough.

    • rkaganov's avatar
      rkaganov
      Regular Visitor
      2 years ago

      Dear Ibendlin,

      Thank you for clarifying the specific issue. I understand that the previously suggested module alone might not be sufficient for generating personalized reports.

      I'm looking at how to combine the original module with other modules like List Rows and For Each might allow iterating through user IDs, filtering the Power BI report through appropriate actions, and then generating individual PDFs using the existing module.

      The goal is to generate a personal pdf report and not a common report for each user.
      The visuals should be updated before the pdf is created.

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        The Export action includes a rerendering of the report pages according to the supplied filters.

         

        If your report is slow this may result in unrendered visuals being included in the PDF. Make sure your report renders fast