I’ve realized a lot of limitations of using Power BI on Microsoft's Report Server, and I want others to be aware of the following challenges:
Can’t create reports in the browser
There are no dashboards
There are no datasets, so no sharing between reports
Can’t create content packs
Can’t analyze in Excel
Can't have many-to-many relationships
No quick insights
No data alerts
No full-screen mode
No R visuals
No preview features
Less updates and improvements
Some custom visuals from the Microsoft Power BI Community do not work
It really seems as though Microsoft Report Server was designed for SRSS, and Power BI is only an afterthought. It’s so bad that I may recommend that we don’t use it and we continue with the cloud service. Yes, even with the Power BI Pro license requirements for consumers of private content.
Hopefully Microsoft is listening and will integrate Power BI into Report Server to a level that it is useful and sustainable. (not holding my breath) Until then, please, be advised to responsibly evaluate your investment into this makeshift solution. I've spent a considerable amount of time learning this valuable lesson.