Forum Discussion

RakeshP's avatar
RakeshP
Icon for Helper I rankHelper I
10 years ago

Power BI Vs SSRS

Hi All,   I was curious to know what made MicroSoft to develop Power BI as SSRS is already existing.   What are the additional features Power Bi has beyond SSRS??   Is there any specific criter...
Need Help
JulieGueho's avatar
JulieGueho
Regular Visitor
10 years ago

Power BI is free... until you use any paying feature including workspaces for collaboration, content packs for publishing or gateway if you have no vpn to your databases. So virtually all you need for a professional deployment is a pro feature which means that from creating report to consuming dashboard, you will need a pro account.

COMtrac's avatar
COMtrac
Icon for Advocate I rankAdvocate I
9 years ago
Our issue is that our clients are government based and our software sits on there servers. Power bi requires them going out to the cloud which from government security view is undesirable. Plus it requires each user to have there own log in. One client has over 1000 users. I'd be interested in any advice from anyone who has faced this issue
  • Amir2550's avatar
    Amir2550
    Frequent Visitor
    9 years ago

    Did you find any solution for this issue with PowerBI, I also suffering for the same, due to security reason we are looking for a solution to store our data locally.

    • amananwari's avatar
      amananwari
      New Member
      9 years ago

      MS recently announced Power BI Premium which support dedicated powerbi service resources as well as on-premise deployment of power BI reports on top of Power BI report server. One of the things in the offering is no need for per user costing. Check out Power BI Premium license.

  • CasB's avatar
    CasB
    New Member
    9 years ago

    Licensing is an issue - especially when it comes to cost.

     

    The way we had the cloud issue resolved here in NZ, we had the local Cloud Suppliers go through a Government Security Vetting which verifies that their infrastructure/platform conforms to Military Grade security. That bypassed the issue regarding security.

     

    As for licensing, because it may be prohibitive, some organisations have opted for more cost effective options thus using powerBI internally and other tech externally.

     

    Hope this helps

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    For use cases where the cloud is not an option, the on prem solution is Power BI publish to SSRS.  It was developed for this exact scenario, as Power BI service sits in public Azure (no express route connection).  As for having many users, you can add security groups or AD groups, so you don't have to manually add each user individually.  This also applies for RLS set up in Power BI desktop.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Have you tried the option of Power BI Report Server? It comes free with SQL Enterprise version. The enterprise users would not need any license to vew resports.

    • luisrh's avatar
      luisrh
      Icon for Responsive Resident rankResponsive Resident
      7 years ago

      Power BI for Reporting Services is only 'free' when you have an Enterprise Agreement with Microsoft and are using SQL Enterprise.   It does work well for on premises scenarios and there is a lot you can do that the Power BI Service does.   You have the flexibility of self service power bi reports as well as being able to create and publish SSRS reports.