November 6, 2019 at 9:03 pm
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.
November 6, 2019 at 9:53 pm
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.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
November 6, 2019 at 9:58 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply