topic Re: Export To File for Power BI Reports does not load all data before capturing PDF in Power Automat in Developer

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

LewisWeal — Mon, 08 Mar 2021 13:08:26 GMT

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.

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

Anonymous — Wed, 10 Mar 2021 06:35:52 GMT

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

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

LewisWeal — Wed, 10 Mar 2021 08:43:33 GMT

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

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

Anonymous — Wed, 10 Mar 2021 09:21:16 GMT

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

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

LewisWeal — Wed, 10 Mar 2021 09:33:57 GMT

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

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

Anonymous — Thu, 11 Mar 2021 08:10:29 GMT

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

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

LewisWeal — Thu, 11 Mar 2021 08:58:21 GMT

Hi @Anonymous, I cant find anywhere contact information for the suport team. Would you be able to pass this through or know the email to contact?

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

Anonymous — Tue, 16 Mar 2021 02:47:16 GMT

HI @LewisWeal,

For power bi support, you can take a look at submitting support tickets:

submit a support ticket

Regards,

Xiaoxin Sheng

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

parveen_f_kumar — Mon, 28 Apr 2025 13:58:54 GMT

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