PowerBI reports and dashboard on-premise hosting
As per available documentation, power bi reports and dashboards will be published to microsoft cloud. It is very awesome approach as it saves all overhead of maintaining infrastructure. But there are case where on-premise hosting is required, Can we configure on-premise server to host power bi reports just like SSRS reports?
With Power BI Report Server now generally available (https://powerbi.microsoft.com/report-server/), we’re marking this idea completed. I want to take this opportunity to thank each and every one of you for participating in this community over the past few months and taking time out of your busy days to try the previews and share your feedback; I can’t overemphasize how much we appreciate it and how much it contributes to the product.
In case you missed it, check out our recent blog post, “A closer look at Power BI Report Server” (https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/17/a-closer-look-at-power-bi-report-server/).
While the June 2017 release supports Power BI reports that connect “live” to Analysis Services, we’re hard at work on integrating the Power Query/M-language and Analysis Services/DAX engines to unlock direct connectivity to the other Power BI Desktop data sources, targeted for later this (calendar) year.
We’ve now created a “Report Server” category for your ideas. Have an idea for a feature you’d like to see in a future release of Power BI Report Server? Submit it here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/category/207604-report-server.
Just create a PowerShell script with the following code and create a task scheduler job to run a few times during the day while MS figures out why this changed.
del C:\Program Files\Microsoft SQL Server Reporting Services\RSServer\LogFiles\*.* /s /q
Yes, I just applied the patch yesterday and my C drive is now full. Our dump files were about 172 MB every couple of minutes.
Srinath Pedi commented
@RiccardoMuti - After installing the suggested patch. The reporting server is generating huge dump files. We had over 90 GB of dump files within 3-4 days. The reporting server has couple of reports that were rarely used.
Did anybody else saw similar files on their test server? The files were created at
C:\Program Files\Microsoft SQL Server Reporting Services\RSServer\LogFiles
@RiccardoMuti - reiterating @Ryan's question... Can we get an update on the CTP eval
expiration? It expired after about 5 weeks and we are unable to proceed with our proof of concept.
@RiccardoMuti - appreciate all the updates. We installed the CTP on 2/13/17, and yesterday we started getting an error "The evaluation period for this instance of Microsoft SQL Server Reporting Services has expired. A license is now required." Is the CTP not 180 days? Any way to extend? Thanks!
We're targeting May for our next preview.
Any updates on the next iteration of the Technical preview?
Sunil Kadimdiwan commented
Any plans to release one more interim version?
@AndyKM.Wong, dcb, as I mentioned below, we don't yet have information about the licensing model or pricing.
I too, am very interested to know if we'll have to pay for PowerBI licenses for a *total* on-premise solution with frequent updates of datasets. We're already a microsoft shop with SQL Server Std., Sharepoint, SSRS. So, will we have any additional or increased costs if we want to display dashboard-looking PowerBI reports in SSRS and/or SharePoint?
Does this release only need to purchase the license for SSRS 2016 but not need for Power BI Desktop ?
Few Questions for Power BI Desktop with SSRS 2016 for On Premises Hosting :
1. Does this release applicable to all version of SSRS 2016 ?
2. Does this release only need to purchase the license for SSRS 2016 but not need for Power BI Desktop ?
3. Purpose of this release for Power BI Desktop is user self served the reporting but administration & hosting keep in SSRS 2016 ?
@Frank, features per edition is part of the licensing model, which is TBD.
@dmnc, you do need to store and manage the reports in Reporting Services, not in SharePoint. Then, if you like, you can embed reports into SharePoint and other apps -- for example, using a Page Viewer web part and the rs:Embed=true URL parameter.
Frank van Zuilen commented
Which edition would support this kind of functionality? Enterprise or Standard as well?
OK so I just tried the technical preview, I created a power BI report then I go to deploy it (Save as....) at that point I think it wants to deploy to reporting services, as in the version that ships out of the box with SQL Server. However, we and I imagine a lot of other people use share point, I believe (I may be wrong though) that to have both on the same server is not wise. With that in mind, is it possible to deploy directly to the share point site in the same manner as we do with our reporting services reports? thank you.
@Matthew, licensing is TBD. I'm eager to find out as well :)
@Anonymous, today, you can use a Page Viewer web part (iframe) with the rs:Embed=true URL parameter.
@Sunil, we're targeting "mid-2017," not necessarily June, and I'd expect the next release to be called something other than "2016."
Matthew Houston commented
Since this is going to be a stand alone with vNext, will it require a separate license for those of us already paying for 2016. Would software assurance cover this?
Its a great feature, Can we use Power BI in SSRS to embed with on-premise SharePoint 2016 web parts similar to paginated reports?