PowerBI Premium & Report Server announcement part 1

So Microsoft have announced something extremely significant for me this week…they are launching soon the powerBI premium with the reporting services for the On Premise solution (something many clients that are not so happy with the idea of moving to the cloud were really waiting for and I have written about it here: Link to On Premise PowerBI Architecture).

The exciting announcement of the Report Server was made in the technet blogs site.

The white paper following the Report Server announcement can be found here to download

The White Paper that was introduced yesterday, is revealing a bit more about the Reporting server and the future directions for the on premise version of PowerBI. I have discussed the on premise PowerBI option in my post about a month ago and came to the conclusion that it might be too soon. So…Are we there yet? I mean after publishing and including all the planned features that are part of the release?

“The new Report server will trace the roots into the existing SQL server reporting services.” (according to the White Paper referenced above). The creation of the reports is done through the PowerBI desktop, but what about the delivery?

  1. PowerBI mobile App
  2. Mobile Browser (meaning uploading the reports to the cloud the dedicated to the organization through Premium or mutual one)
  3. Embed into an application (meaning uploading to the cloud, grab the API and embed it in the application or use the SharePoint web part)

Unfortunately for some of us, there are clients who still think, even after the dedicated hardware solution, that the cloud is not an option. Therefore even after the new features and the exciting solution are implemented, there are still some clients who are going to stay out of the game.

On Premise PowerBI, what’s in it for the organization?

About a year and a half ago I have witnessed a very interesting interaction between a consultant and a client. The client kept insisting that they wanted a PowerBI based solution, the free dashboard one, and that they cannot join the cloud. PowerBI was only just getting started. The consultant, created an Excel report, using Power Pivot and Power query from the clients SQL data base and…he added a black background. I found it genious, the client was super excited and added it in their SharePoint site as the “on premise PowerBI”.

Reminds me of:

Well what was changed since?

The online version has developed into a “connect everything” model and the advantages seem to be enormous comparing to many other platforms. While the on premise version lacks the maturity to be implemented in the organization. (In my humble opinion).

Let’s review the necessary components and the options we are presented with by PowerBI:

  • Connectivity to the on premise DB
  • Synchronization with the DB
  • Access to data according to permissions levels (Autentication)
  • Publishing the data in a portal solution
  • Self Service BI
  • Usability and access log

The closest model that Microsoft is suggesting in the Governance whitepaper is:

Well, it still does include the cloud for:

  1. Authentication
  2. Publishing
  3. Logs

What if we have an organization that does not include an internal SharePoint portal and Azure AD to authenticate with?

So we get the following architecture:

This particular architecture has many disadvantages:

  1. It allows multiple copies by multiple users and the data governance can hardly be implemented- the same problem Excel spreadsheets are creating, and getting read of stand alone Access or Excel solutions just to get a better looking one is not an option
  2. The synchronization is done manually, each time the .pbix file is opening, through a local client that must be installed on the machine
  3. The authentication and synchronization is performed by the DB itself, if the organization doesn’t have the AD implementation
  4. There are no usability logs, they are created in the desktops per user

I have thought of a creative solution for problem no 4, build an aggregator and a timer job that is going to connect and collect the data to a PowerBI report on one of the administrators machines. This is not exactly feasible…but I get some points for creativity. 🙂

What does PowerBI still has to offer?

Well the Self Service BI option, friendly interface comparing to other Enterprise solutions and recently ability to later use the data sets as data sources.

In conclusion, in order for PowerBI to work on premise, I would love to see if the integration can work great on something other than Office 365. Not all the organizations are willing to move to the cloud, and right now I feel that PowerBI lacks a few features to be a leading product.

So if we quickly sum up the current state, I would like to add that

PowerBI on premise? well maybe…not just yet

Requirements PowerBI on premise
Connectivity to DB Direct query direct access to DB
Synchronization Client, slow and authentication against DB each time
Permissions PowerBI gets the permissions form AD application or public to all the users who have access to the cashed data in the report, if the data was imported
Publishing Stand alone files

Can be reused as data sources

Self Service BI Stand alone, flexibility and easy interface
Activity log Log only, on premise don’t have a viewing tool