Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to Automate a process that would export a Power BI report in PDF format and send an Email on a scheduled basis with that PDF as an attachment.
Is that possible without passing by a premium capacity?
Hi @Anonymous @FabioFe
To export your Power BI report to PDF with filters and slicers (with a Power BI Pro license), see https://medium.com/bi-helper/automated-distribution-of-power-bi-reports-and-dashboards-25fde6c68af0.
BI Helper is a third-party SaaS tool that automates the generation and emailing of PDF / PPTX reports from Power BI to users inside and outside your organization.
Is it possible in Power BI Pro?
Yes it works with Power BI Pro.
Hi @Anonymous ,
You can use power automate works with power bi service. But this need the report stored in reserved capacity. This means need a premium capacity. For more details, you can refer this article.
Export and email a report with Power Automate - Power BI | Microsoft Docs
The REST API is the same and you can refer to this article on the limitations of exporting to a file.
Export Power BI embedded analytics reports API - Power BI | Microsoft Docs
Or maybe try some third-part tools like javascript or python selenium to get pdf.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous I don't think you need Premium for that, you could use the Power BI REST API.
Thanks @Greg_Deckler for your reply
There are any steps that i can follow to achieve this goal?
@Anonymous Sure:
1. Install Powershell
2. Read this: Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Docs
3. Read this: Working with PowerShell in Power BI | Microsoft Power BI Blog | Microsoft Power BI
4. Read this: Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Docs
5. Code it
Power Automate uses the PowerBI REST API and has the same limitation. The report needs to be a dedicated capacity. See: https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-to-file#limitations
Did it work? How did you implement it finally? Would it be possible that you provide insights?
Best,
Fabio
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |