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?
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.
Hi @ikramelmbarki ,
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
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.
@ikramelmbarki 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?
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
Did it work? How did you implement it finally? Would it be possible that you provide insights?
Vote for your favorite t-shirt design now through March 28.
Find out more about the March 2023 update.
Find out more about the online and in person events happening in March!