Export Power BI Report in F2 workspace as PDF using Power automate

[GuillaumeR57]

Hi,

I have to export a power bi report with changing parameters as PDF and send it by email. The best way to do it use to be with Power Automate. 

Unfortunately, we only have premium licenses per user and as the following documentation specifies that we need one workspace per capacity to do it :

Export and email a report with Power Automate - Power BI | Microsoft Learn
So I was wondering if taking a Fabric F2 workspace would be enough to perform this task, knowing that Fabric workspaces will replace those by capacity? 

And if not, could there be an alternative?

Thank you in advance for your help

[KiranHosakote]

Hi @GuillaumeR57 

Generating end user-specific PDFs (filtered / sliced) and emailing them on a regular schedule / on-demand has no ready solution from Power BI unless you move to the Premium capacity. Power Automate has some limitations too, as you must have seen. 

If you are open to using third-party solutions, BI Helper https://bihelper.tech may meet your requirement.

BI Helper is a popular and easy to use SaaS application that automates the generation and emailing of user-specific PDFs (with filters and slicers applied). It is secure, scalable and works with a Power BI Pro / PPU license for the sender. It doesn't require Power Automate or any other add-ons and the PDF recipients only need an email ID, any email ID will do. 

[GuillaumeR57]

Hey, thanks for your reply

I think I would need dynamic subscriptions to handle parameters ? 

But it needs a workspace with a capacity as is it stated here 

Dynamic subscriptions for Power BI reports (Preview) | Microsoft Power BI Blog | Microsoft Power BI

[djurecicK2]

Hi @GuillaumeR57 ,

 As an alternative, you could look into subscribing your users to reports:

https://learn.microsoft.com/en-us/power-bi/collaborate-share/end-user-subscribe?tabs=creator