Hosting PowerBI in SSRS

  • hawaiianrebel

    Old Hand

    Points: 343

    Overview

    I have been tasked with the question is there a tool that can host PowerBI reports other than PowerBi Reports Engine?  The problem I believe is licensing.  We have license for SQL Server Enterprise 2017 that includes SSRS & SSAS.

    Question

    Can we host PowerBI Reports in SSRS?  I believe I got the answer in the following post (https://www.sqlservercentral.com/blogs/power-bi-in-ssrs-%e2%80%93-t-sql-tuesday) but that looks like desktop on demand reporting.  So the next question is can it be webhosted?  The report be a live living webpage hosted?  Would I need SSAS as well as SSRS to accomplish this?  What are my options?

    Business Intelligence is not my background, but I was asked to look this up anyway.  Any and all information you can provide would be greatly appreciated.

  • Jeffrey Williams 3188

    SSC Guru

    Points: 88170

    You can use Power BI Report Server - but it has to be purchased and licensed (of course).  It is separate from SSRS - but can also host standard SSRS reports as well.

    https://powerbi.microsoft.com/en-us/report-server/

    You can also publish in the cloud - and that also has licensing, but it only requires those users sharing the dashboards to be licensed.

     

     

    [font="Verdana"]Jeffrey Williams
    Problems are opportunities brilliantly disguised as insurmountable obstacles.

    How to post questions to get better answers faster[/url]
    Managing Transaction Logs[/url]
    [/font]

  • frederico_fonseca

    SSChampion

    Points: 14211

    if you have Enterprise with SA you can install Power BI Report Server on the same licensed server instead of the standard SSRS installation - PB RS is a superset of SSRS containing the same exact functionality as SSRS plus the capacity to host Power BI.

    If you don't have Enterprise with SA then your only option is the service based Cloud option (quite expensive) which also allows you to have a on prem server with number of cores associated with the tier you "rent" on cloud.

     

    Regarding your comment "like desktop on demand reporting" - PowerBI Desktop is that indeed - having PowerBI Report server is only to host it and be available for other users to use as "end users".

    Note that those deploying/publish a pbix to any Power BI Server (being on prem or cloud) also require a license for Power BI Desktop pro - around 10 Euros per month.

    For standard use on desktop there is no licensing requirements.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply