Power BI - steps to connect Essbase using Essbase Connector (beta)

There is a request from the Essbase & Power BI community to provide an official connector for connecting Essbase from Power BI. It started exactly 4 years back and Microsoft was delaying it for long time. Finally on Nov 7, 2018 the request has been taken care and moved from under review to backlog status.

Few days back we got our first beta version of the connector as well,

With a Warning!
The Essbase Connector is still under development. Please try it out and give us feedback. We can’t guarantee it will work the same way in the final version. Future changes may cause your queries to be incompatible.

Though, I wanted to give a try.

power-bi

Essbase Connector

The connector is listed under the Database tab when we select Get Data or you may search for Essbase on the search box. Selecting Essbase and clicking connect would take us to the next window, which requires us to provide the Essbase server details.

Essbase Server Connection String

Since Microsoft did not provide any official document on connecting Essbase through power BI, I have tried multiple ways to connect; but almost everything failed, except one. The connecting parameter should look like this:

1
http://localhost:19000/aps/XMLA

Power BI Essbase Connector

The server name & port number to be modified as per your environment.

Clicking OK would take us to the basic login screen, where we need to provide the login credentials of the Essbase server.

Power BI Essbase Connector

The Navigator screen displays the list of applications available in the server. Expanding an application displays the plan types in a format of application name.plantype.

Power BI Essbase Connector

Expanding further, displays the list of members from Account Hierarchy in improper order. Microsoft might need to fix it to display in a proper order / hierarchy way.

Designing Report / Dashboard

Selecting the required Account codes and required dimensions from the list provide us the fields to design report in hierarchical order.

Power BI Essbase Connector

Update
The next post: Power BI and Essbase - Initial Experiments explains further about Power BI - Essbase Connector.