send paginated report in excel and pdf format as email attachment

[powerbiexpert22]

can we send paginated report (after conversion from ssrs) as an email attachment in excel or pdf format from power bi service?

if yes then do we need premium license for this? 

[v-kaiyue-msft · Accepted solution]

Hi @powerbiexpert22 ,

Thanks @3CloudThomas  for sharing, I have some additions here.

1. You can set up email subscriptions for paginated reports for yourself and others in the Power BI service. Generally, the process is the same as subscribing to reports and dashboards in the Power BI service. Paginated report subscriptions in Power BI service are similar to email standard subscriptions in Power BI Report Server and SQL Server Reporting Services. When you set up your subscription, you can choose how often you want to receive emails: daily, weekly, or hourly. Subscribe to a PDF attachment containing the entire report output.

2. Subscribing to others requires a paid license (Pro or PPU). The Power BI administrator must enable the subscription in the tenant. Additionally, the relevant tenant switches must be enabled.

For more information, please refer to the document: Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn.

3. You can see all the options now because you are trying Microsoft Fabric, which can create a workspace that supports Fabric functions. For more details, please refer to the document: Types of licenses for Power BI business users - Power BI | Microsoft Learn.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[3CloudThomas]

You can create a subscription to send rendered report as a format.

[powerbiexpert22]

@3CloudThomas  subcription allows only pdf and powerpoint in power bi service

[3CloudThomas]

Yes, you need a Premium or Fabric capacity to be able to export to pdf or other formats. Pro license is not enough. 

[powerbiexpert22]

@3CloudThomas 

what is the process for sending files?

[powerbiexpert22]

i can see all format options for paginated report , my report is hosted on normal workspace