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

[LewisWeal]

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.

[LewisWeal]

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

[parveen_f_kumar]

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

[Anonymous]

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]

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

[Anonymous]

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

[LewisWeal]

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? 

[Anonymous]

HI @LewisWeal,

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

submit a support ticket

Regards,

Xiaoxin Sheng

[Anonymous]

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