Hello,
I am looking to use Power Automate to export PDFs from a BI report & have this emailed to a team daily. I have a BI report saved to our shared workspace and have created a flow in Power Automate to send PDF emails of that report.
When I test the flow, I am getting the "Forbidden" error message on the "Export to file for Power BI Reports" step. When I check the messaging, I can see the following error message "Report requested for export is not on dedicated capacity". I have researched these errors & it appears I need the Power BI Premium license for this flow to work, but haven't been able to find a concrete yes or no. Is premium needed to run this automated flow?
I have Power BI Pro & the standard version of Power Automate. Attached images of the flow & error.
Thank you for taking the time to read/respond!