skip to Main Content

Chris FinlanThe Man, The Myth, The On-Prem Server Guy…

Chris Finlan and I have known each other for some time now. He emailed me out of the blue 3.5 years ago and we’ve been in touch ever since.  In 2014 he was a Technical Sales Professional at Microsoft, based out of the DC/Philly offices, but for the past 2 years he’s been a Program Manager (my old job) at MS HQ in Redmond, WA.

An Excel Pro in a former life, Chris knows the score on how things go down out here in the Real World.  I find that incredibly valuable, and we’re all lucky to have people like him working on the software that powers our careers.

Chris works on some very important stuff these days, and he “sat down” with me for a virtual interview.

The On-Prem Alternative to the Power BI Cloud

A Power BI PBIX Rendered in the Browser, by an On-Premises Server!

Hotness!  A Power BI PBIX Rendered in the Browser, by an On-Premises Server!

So Chris, what is the name of the server product you work on? Power BI On-Prem? SSRS vNew?

It’s called Power BI Report Server. It’s even got its own landing page on the website

And what do I have to buy in order to get it?

You can buy Power BI Premium and get rights to it, or you can buy cores of SQL Server Enterprise Edition with software assurance.

The thing that’s most exciting (to me anyway) in this latest preview is Web Excel rendering (sometimes called Excel Services or EWA). It’s using Office Online Server just like SharePoint 2016 is doing, but we’ve simply narrowed the supported scenarios down to Excel only, just like the Power BI service.

An Excel Power Pivot Report Rendered in the Browser, On Premises, With No SharePoint!

Ooh!  And an Excel Power Pivot Report Rendered in the Browser by the Same Server.
(And just as importantly…  no SharePoint required here!)

What motivated you to do the work to add this to Power BI Report Server?

This has been something has been discussed for years – the idea you could have a single server that simply runs the Microsoft BI stack without having required external dependencies on something like SharePoint. Excel represented the final piece of that puzzle, so between that and a desire to have a similar story for customers when it came to Excel with the Power BI service, we pushed ahead.

Well, that and being bugged about it for the past 18 months.

I appreciate you tolerating my long-running “gimme EWA” narrative.  I ran some massive Power Pivot for SharePoint farms in a former life, and it was not pleasant.  Is Power BI Report Server easy to install and configure?

We tried to make it as easy as possible for folks while still acknowledging that Office Online Server still requires you to do a few things in PowerShell to set that up. The feedback so far is that it’s much easier to setup for folks than what was required in the past with SharePoint, so that’s been great to see.

So is it fair to say your server is also a web server? Do I have to futz with IIS settings or is it appliance like?

No, Power BI Report Server takes care of that for you basically. You simply do the same things you’d do in SSRS (SQL Server Reporting Services) once you’ve installed it by walking through the configuration experience, and you should be good to go.

Can I embed the Excel Web control in other pages, suppress the toolbars, etc. like I could with SharePoint?

You can only embed it in an iFrame and hide the Report Server in chrome using a simple URL pattern (rs:embed=true), so we have basic embedding support but that’s all. We essentially have the same experience as the Power BI service for Excel, so it’s more like that vs. the full Excel Web Part for SharePoint.

That’s actually a much better answer than I expected, especially for a first time out.  Kudos! 

Your server also runs PBIX files right? And can deliver to mobile devices?

Indeed it can (as pictured at the top of this interview) – both Power BI Reports and Mobile Reports based on the Datazen technology we acquired and were first introduced in the SSRS 2016 are supported and available through the Power BI Mobile App.

A Power BI PBIX Rendered in the Browser, by an On-Premises Server!

MOAR Power BI!!!

What kinds of customers are using versus Power BI cloud?

For a lot of customers, especially in certain industries, they still have certain groups that require a solution to run in their data center, so going with something like Power BI Premium gives them rights to run in the cloud AND on-prem with a P1 SKU. We also have customers that are heavy SSRS shops that just want to take advantage of the additional capabilities of Power BI Report Server, since they have the rights to run it based on their existing Enterprise Agreement.

Yep, we run into those kinds of companies all the time.  We encourage Power BI cloud where possible, but for some industries or orgs, it just isn’t politically or legally feasible.

So… can we just call your server “PBI On Prem?”

No. No you may not.

OK fine, we can’t call it that today. WHEN can we start calling that?

Never, and I think this is actually an important point to touch on. There’s no plans to have parity between the service and the server for things like dashboards, Q&A, etc. The focus of the server is and will continue to be “Reports”, hence the name Power BI Report Server.

Oh my gosh while trying to close ONE can of worms you have opened up a BIGGER one! What does “report” even mean?

Power BI “does” reports. Everything’s a report, in some sense, and everything’s a dashboard. This is a longstanding impossible semantic nuance. In any event, how we frame the report conversation with customers relates back to the post in October 2015 and how we defined reports in that roadmap discussion. That seems to make sense for most folks I talk to around this topic.

An Excel Power Pivot Report Rendered in the Browser, On Premises, With No SharePoint!

Is this Web Excel Example a…  Report?  In the Real World, Yep.
(But MS still insists on re-purposing our perfectly-good nouns – hey, they make awesome software.  Naming doesn’t HAVE to be a strength.)

(Just so you know, folks, I have a hobby, and that hobby is called “Make Chris Finlan Uncomfortable.”  It would be inauthentic of me to NOT inject some of that here, and I still think “Power BI On-Prem” is a fine name for this awesome product, but that’s not for me to decide – lots of big strategic stuff at Microsoft, behind the scenes.)

This new functionality is in preview… when does it become “real?”

In the next few months.  In the meantime, check out the preview – go ahead and download it below:

Power BI Report Server Preview - Click to Visit the Download Page

Click to Visit the Download Page

Rob Collie

One of the founding engineers behind Power Pivot during his 14-year career at Microsoft, and creator of the world’s first cloud Power Pivot service, Rob is one of the foremost authorities on self-service business intelligence and next-generation spreadsheet technology.

This Post Has 8 Comments
  1. Few Questions and Limitations
    1. Does PowerBI report server fit in 3 tier architecture (i.e. web, App and DB)
    2. It still does not support connecting to SSAS Tabular via https(i.e. using msmdpump.dll)
    3. PowerBI cannot connect to more than one Tabular Model via Live connection
    4. There are many visualizations which cannot work offline and needs internet connections (Eg: Fill Map, Narrative )

  2. This is a great innovation in its own right. However, It doesn’t matter what new fangled feature comes along if the majority will never feel the benefit

    The structural awkwardness / shackling in delivering the collaborative side of Power BI is once again exposed by this question: “And what do I have to buy in order to get it?”. If I have 100 potential casual dashboard consumers then I have to make the case for 100 pro licences, Power BI Premium or something about cores. My case is simply dead in the water unless I’m somewhere greenfield

    Microsoft have their foot on the throat of the biggest potential breakthrough and domination in BI since Excel itself. All they need to do is make the consumable side of Power BI available through elevated versions of Office and thus absorb the cost of it that way. I’m honestly gobsmacked that someone cannot take the helicopter view above all of these development silos for the strategic good of the product

    I’ll keep on pedalling the below through my own frustration and because I know its right from being at the coal face and trying to get traction

      1. Thanks Chris. Yes, was aware of E5 SKU and even asked IT recently on the possibility of getting it (to no avail)

        I should have been a bit clearer on the above: Pro Licences aren’t the issue per se and I’ve no objection to content creators paying their way

        What I was hoping would come along is a ‘free’ Power BI reader view where the cost increase for a regular Office user on a more standard SKU would be negligible. NB for content consumers not creators

        If you could incorporate this reader view in the form of an integrated app within Office then you’d not only open up your potential audience and generate awareness of Power BI but also nurture those hidden purple people towards creating their own content and thus buying pro licences

        I think an organic approach could lead to a tipping point where the amount of requests for pro licences would make it sensible to move to Premium or the E5 SKU

        Shackling the collaborative side of Power BI with the current barriers to entry is turning people away from the product and curtailing its potential uptake. I’m concerned that’s a massive strategic fail

  3. Thanks Chris.

    Why should we buy a SQL Server Enterprise Edition with software assurance or a Power BI premium license to be able to deploy PBIX file on-prem. These one are very expensive.

    This requirements is a limitation to the massive use of Power BI in SME.

    MSFT should open it to the SQL Server Standard Edition.

    Best Regards,

  4. 100% agree. Now that SSRS reports are very popular, I think Power BI reports will enhance the usage of MSSQL lot more. By offering it with SQL standard, lot many users can take advantage of the dashboard features which SSRS lacks. Price difference between SQL standard and Enterprise is way too high for many customers and just for Power BI many can not justify. Thank you for considering.

Leave a Comment or Question