Forum Discussion

LewisWeal's avatar
LewisWeal
Frequent Visitor
5 years ago

Export To File for Power BI Reports does not load all data before capturing PDF in Power Automate

Hi, The 'Export To File for Power BI Reports' does not load all data before capturing PDF. It downloads the PDF as blank in some visuals and still shows the loading Icon in the top left of a visua...
Need Help
LewisWeal's avatar
LewisWeal
Frequent Visitor
5 years ago

Hi Anonymous and thank you for responding,

The feature is called  'Export To File for Power BI Reports' in Power Automate (Apoligies I should of mentioned). This was downloading files into PDF for us.

We do use the AS live connection and not direct query. I have thought about switching to direct query just to do this task however the data source wont allow me to do this without rebuilding reports. 

The flow in Power Automate is:

1. Trigger
2. Export To File for Power BI Reports
3. Email file

This has worked perfectly in the past however now it seems it wont allow PowerBI to load the data before capturing the PDF. So when the PDF is sent out, the visual appear blank.

Kind Regards
Lewis

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi LewisWeal,

    >>This has worked perfectly in the past however now it seems it wont allow PowerBI to load the data before capturing the PDF. So when the PDF is sent out, the visual appear blank.

    It probably is one reason that causes the issue. Have you tested to apply this to a report with a common dataset? (e.g.  import mode) I'd like to confirm if this issue related to the feature itself or only appears with a specific environment/scenario.

    Regards,
    Xiaoxin Sheng

    • LewisWeal's avatar
      LewisWeal
      Frequent Visitor
      5 years ago

      Just tested with using the common dataset and works with no issues. It just seems an issues with the live connection. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI LewisWeal,

        >>Just tested with using the common dataset and works with no issues. It just seems an issues with the live connection. 

        I think you can contact the support for power bi or power bi automate and ask them to trace the backend processing to confirm this.
        Regards,

        Xiaoxin Sheng

  • parveen_f_kumar's avatar
    parveen_f_kumar
    New Member
    1 year ago

    hello LewisWeal ,

    i also have the same request, where i need to export report to pdf and my power bi reporting is using AS live connection along with RLS implemented at AS level. Can you please assist how to set to set up that in automateflow because i am not able to find a way.

     

    Thanks,

    Parveen