Hi mjsystemss, 

That is correct, a pro license is not enough to do this, you need to have a premium or fabric capacity.  

This is outlined here: 
Export and email a report with Power Automate - Power BI | Microsoft Learn

To follow along, make sure you have the following prerequisites:

• At least one workspace in your Power BI tenant backed by a reserved capacity. This capacity can be any of the A1/EM1 - A6/P3 SKUs. Read more about reserved capacities in Power BI Premium.
• Access to the standard connectors in Power Automate which come with any Office 365 subscription.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.