Hi,
We are in the exact same situation.
We have 2 options to embed reports in SharePoint Online:
- Use the Power BI webpart > it requires the Pro licenses for all our audience (500 users) which is not affordable for us
- Use the Publish to Web > it makes the report public which is not acceptable
The fact that we could embed easily reports in SPO was really a good point for the O365 suite and PBI.
But those 2 limitations hurt both SPO and PBI adoption.
C'mon you imagine me explaining to my management that we need to pay 10$ * 500 * 12 = 60K$ just to display few charts on our intranet??!
Let's be serious one moment please...
We planned to purchase 30 Pro licenses but if in the end we cannot publish the reports to the organization without making it public, then I think there will be no Power BI at all..
We NEED a way to publish reports to the organization without requiring a Pro license for every user. (Period)