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 visual.

We are using Analysis Services as a data source in Power BI.

This has only just started to happen and the data does load in Power BI.

Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI LewisWeal,

    What type of feature are you work on? 'Export report data' or 'export to pdf'? Please share more detailed information to help us clarify these.

    How to Get Your Question Answered Quickly 

    BTW, Do you work on AS data source with live connection mode?
    Regards,

    Xiaoxin Sheng

  • 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. 

    • 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