View My Drafts
The short answer is a license is required, but there are two ways to license Power BI embedded content with SharePoint:
1. Every user viewing the report in SharePoint has a Power BI Pro license
2. The workspace the report is in, is backed by premium capacity.
For more details - https://docs.microsoft.com/en-us/power-bi/service-embed-report-spo