cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JimKingPowerBI Regular Visitor
Regular Visitor

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.

1 REPLY 1
Highlighted
Super User
Super User

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


@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 https://docs.microsoft.com/en-us/power-bi/report-server/compare-report-server-service 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

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (1,912)