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?

2,526 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

sandeep yadav shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  Riccardo Muti responded  · 

Hi everyone,

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.

Thanks!

345 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...
  • Dustin commented  ·   ·  Flag as inappropriate

    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

  • Dustin commented  ·   ·  Flag as inappropriate

    @Srinath Pedi,

    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  ·   ·  Flag as inappropriate

    @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

  • Deon commented  ·   ·  Flag as inappropriate

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

  • Ryan commented  ·   ·  Flag as inappropriate

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

  • dcb commented  ·   ·  Flag as inappropriate

    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 ?

  • AndyKM.Wong commented  ·   ·  Flag as inappropriate

    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 ?

  • AdminRiccardo Muti (Admin, Microsoft Power BI) commented  ·   ·  Flag as inappropriate

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

  • dmnc commented  ·   ·  Flag as inappropriate

    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 Houston commented  ·   ·  Flag as inappropriate

    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?

  • Anonymous commented  ·   ·  Flag as inappropriate

    Its a great feature, Can we use Power BI in SSRS to embed with on-premise SharePoint 2016 web parts similar to paginated reports?

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.