Exporting Power BI Reports as PDFs and Sending to Recipients Using Logic Apps

Question

How can I use Logic Apps to export Power BI reports as PDFs and send them to different recipients? Specifically, I need to export the reports based on specific dimensions (such as filters or categories) and automate the process of emailing the PDFs to the respective recipients. Additionally, what subscriptions or access levels do I need (e.g., Power BI Pro, Premium, or Azure services) to implement this effectively?

Answer 1

Hello @Azure Subscription,

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

To automate the process of exporting Power BI reports as PDFs using Azure Logic Apps and then sending them to specific recipients,

• First to create Logic App, Go to Azure Portal then navigate to Logic Apps their clink on create and then set up a trigger (e.g., Recurrence for scheduled runs).
• Next to export Power BI Report, add Power BI action: Export to File for Power BI Reports and authenticate, choose your workspace, report, and file format (PDF).Optionally, apply filters for specific dimensions (e.g., category or date).
• Next to email the PDF, add Office 365 Outlook or SendGrid action to send emails and attach the exported PDF and specify recipients.

Access Requirements:

• Power BI Pro or Premium for report export.
• Azure Subscription for Logic Apps.

Hope the above provided information provided will helps you in better understanding and solve your concern, if you have any question, please feel free to reach out.