Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Limitations of Power BI on Report Server... Be Advised...

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.

Super User II
Super User II

@JimKingPowerBI wrote:

.. I may recommend that we don’t use it and we continue with the cloud service. 


Power BI Report Server is never going to be as feature rich as the cloud service. If you can use the cloud service you definitely should stick with that.  


All of those limitations are pretty well covered in the documentation I'm hoping that over time we will see some items removed from that list over time, but I would not expect PBIRS to ever reach feature equality with the cloud service.



Helpful resources

November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!


Power Platform October Community Highlights

Check out the top community contributors across all of the communities


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.