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.
Eagerly waiting for an on premises solution of Power BI.
MS/Users what is the status on this project? Can I slate this for a quarter next year for onsite hosting?
This is only way my company will consider this awesome product so please consider it as we might be forced into horrible tableau
We would prefer the choice to host the data on-prem, as opposed to cloud.
Tracy Lockard commented
One of my colleagues is at a PowerBI class and just learned that PowerBI on-premise will require SQL Server 2016 which won't release until after SQL Pass. We would really like to be a full MS shop but we won't deploy SQL Server 2016 until at least SP1. Microsoft needs to develop PowerBI on-premise with SQL Server 2014 at minimum. We are evaluating BI solutions now and like what we see with PowerBI, but this isn't fitting into our plan to have a decision by year-end.
Our company policy is Not to store company data at Microsoft. It couldn't be more clear what happens if we do, thanks to Snowden. That will never change.
We installed Tableau while we wait for an on-prem solution (Sharepoint) from MS.
Pyramidanalytics is a desparate (shortterm) move.
365 is built on top of Sharepoint. So Datazen will most likely be the bridge between Sharepoint and PowerBI.
But there is no known Roadmap for a on-prem solution, and we only take decisions based on what we know.
Evaluating Tableau. Would love to know where this falls on the roadmap as our organization would prefer a full MS solution.
Zahir Baroudi commented
We hope Microsoft will find a solution very soon since regulations in the Middle East forbid banks to publish customer information on the cloud.
Roman Gutjahr commented
maybe after the testing & debugging phase is over?
Alejandro Leguizamo commented
MS team: any comments on this please?
Neville Farrell commented
We really really want to use Microsoft Power BI but without an on-prem solution, we cannot use it. I beg Microsoft to consider this.
David Rushton commented
While newer versions of SQL Server work great as an on-prem solution, I would like to provide my non-IT colleagues with a space where they can rapidly develop and share ad-hoc data models. Company policy prevents us from using a cloud based solution.
Sawan Ruparel commented
Yes. Many healthcare organizations don't want to host data on shared service.
Please don't recommend excel and sharepoint. Please understand why Tableau is popular, even though sharepoint was available before then
Charles Suttie commented
A while back Microsoft announced that it would be moving Office 365 data "in region". For Australians that meant data within our borders at Australian datacentres. To their credit, Microsoft delivered on this. It would be great to see the same thing with PowerBI. I do understand that some enterprises desire an on-premises version. But I think that there is a segment which would be happy with "in region". Ideally, Microsoft would offer both. What I think should be avoided is creating a dichotomy between "data somewhere in the cloud" and "on-prem" because the on prem solution is likely to be very capital intensive. This could be mitigated by using Azure but smaller enterprises would still need to confront the cost and trouble of maintaining their own servers.
I was thinking the Datazen acquisition is meant to answer the on premises problem
This is one of the top 10 ideas for Power BI, many companies just will not allow data in the cloud. Will MS comment on this?
Jerry Cote commented
Excel is solid for onprem BI, and if you stick to using PowerView for reports you want to eventually show online, you'll have that option to move them up, as soon as MS gets its act together on the Personal BI Gateway, which is out there but failing on basic installation procedures as of today and not ready for prime time.
so if it is the idea to decouple power bi from SharePoint on-prem what is the pendant for it on-prem?
Gorm Braarvig commented
I would like this, but as a virtual "appliance" (Hyper-V/nano image(s) with the necessary bits on)