How can we improve Power BI?

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.

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.

A couple of key things to know:
- This Technical Preview is a pre-configured Virtual Machine in the Azure Marketplace. The VM includes everything you need, even sample reports and data, making it quick and easy to give it a try. We wanted to offer it to you while we continue to work toward a preview you can download and install in your own on-premises environment.
- This preview supports Power BI reports that connect “live” to Analysis Services models – both Tabular and Multidimensional (cubes). We plan to extend support to additional data sources in a future preview.

Your feedback about this and future technical previews will help our progress toward production-ready functionality and reliability, so give it a try and send us your feedback!

Two specific goals of that roadmap:
- Step 1, in SSRS 2016: Provide an on-premises solution for mobile BI by adding Mobile Reports (built on the Datazen technology we recently acquired) to SSRS.
- Step 2, after SSRS 2016: Provide an on-premises solution for self-service BI. Power View was a first step in 2012, but we want to provide a solution that works across modern browsers and mobile devices (read: doesn’t require Silverlight) and that doesn’t necessarily require SharePoint.

About that “on-premises solution for self-service BI:” We’re enabling you to publish a Power BI Desktop report to an on-premises report server and view it in a web browser. With SSRS 2016, you can already do the first part: upload PBIX files to SSRS, manage permissions (who can see/download them, who can update/delete them, etc.), and individual users can Favorite them – essentially a nicer alternative to a network share for these files. Currently, clicking a PBIX file does open it in Power BI Desktop, but this is merely an incremental step on the path to enabling in-browser viewing.

We’ve made and continue to make good progress toward that roadmap:
- In June 2016, we delivered Step 1 (on-premises mobile BI) in SSRS 2016.
- Since then, we’ve been actively working on Step 2 (on-premises self-service BI).
- In September, at Microsoft Ignite, we showed the first sneak peek of the progress we’ve made. We demoed viewing and interacting with a Power BI Desktop report in a web browser, completely on-premises. Watch the demo: https://youtu.be/gkOG9HxRpZs?t=58m4s.
- Our next major event is PASS Summit, October 25-28, where we hope to share our latest progress toward a public preview.

Two specific goals of that roadmap:
- Step 1, in SQL 2016 RTM: Provide an on-premises solution for mobile BI by adding Mobile Reports (built on the Datazen technology we recently acquired) to SSRS.
- Step 2, after SQL 2016 RTM: Provide an on-premises solution for self-service BI. Power View was a first step in 2012, but we want to provide a solution that works across modern browsers and mobile devices (read: doesn’t require Silverlight) and that doesn’t necessarily require SharePoint.

Having delivered on Step 1 in SSRS 2016, we’ve now started on Step 2.

About that “on-premises solution for self-service BI:” We plan to enable you to publish a Power BI Desktop report to an on-premises report server and view it in a browser. With SSRS 2016, you can already do the first part: upload PBIX files to SSRS, manage permissions (who can see/download them, who can update/delete them, etc.), and individual users can Favorite them – essentially a nicer alternative to a network share for these files. Currently, clicking a PBIX file does open it in Power BI Desktop, but this is merely an incremental step on the path to enabling in-browser viewing.

We don’t yet have a more specific release timeframe, but we’re actively working on this functionality.

@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

@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!

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 ?

@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.

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.

Ready to get started?

Power BI Newsletter

Take your data to the next level with the best tips and tricks from our experts.

Thanks for signing up for the Power BI newsletter.

By clicking Sign up, you are giving your consent to Microsoft for the Power BI newsletter program to provide you the exclusive news, surveys, tips and advice and other information for getting the most out of Power BI. You can unsubscribe at any time.

Downloads

Whether you are on the go or need to create rich, interactive reports, Power BI offers you the tools you need.