Skip to main content

    Power BI

    Completed

    Hyperion ESSBASE

    Vote (663) Share
    Eric Vogelpohl's profile image

    Eric Vogelpohl on 19 Dec 2014 12:16:37

    Get data from Hyperion Essbase

    Administrator on 13 Apr 2019 01:34:07

    We're glad to let you know that this feature is now Generally Available. Please refer to the Power BI Desktop April release announcement for more details: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2019-feature-summary/ Thanks for your feedback!

    Comments (174)
    Eric Vogelpohl's profile image Profile Picture

    Dan d on 05 Jul 2020 22:18:52

    RE: Hyperion ESSBASE

    Essbase connectivity is critical for us if we're to adopt Power BI.

    Eric Vogelpohl's profile image Profile Picture

    Jim Johnson on 05 Jul 2020 22:18:24

    RE: Hyperion ESSBASE

    We need it to connect to Hyperion Planning/ESSBase

    Eric Vogelpohl's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:18:14

    RE: Hyperion ESSBASE

    Please add the connector, considering that SSRS does have the connector, though pritty rough..
    Thanks and keep going!

    Eric Vogelpohl's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:18:08

    RE: Hyperion ESSBASE

    Please add Essbase as a source. I am a Hyperion practitioner looking for a Tableau alternative.

    Eric Vogelpohl's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:17:29

    RE: Hyperion ESSBASE

    We've had a couple inquiries about this too. Looking for a workaround so we can bring Essbase and PowerBI together.

    Eric Vogelpohl's profile image Profile Picture

    John Cooper on 05 Jul 2020 22:17:24

    RE: Hyperion ESSBASE

    we have a lot of interest in this from several of our customers as is mentioned in the tread, this is a major player in corporate planning and performance management.

    Eric Vogelpohl's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:17:17

    RE: Hyperion ESSBASE

    Getting data from Hyperion Essbase and Hyperion planning will be great.

    Eric Vogelpohl's profile image Profile Picture

    TEEGEE on 05 Jul 2020 22:17:15

    RE: Hyperion ESSBASE

    I'm not familiar with Essbase but from the bit of googling I've done it doesn't seem very easy to connect to from anything.

    This stackoverflow article gives some connection options:
    http://stackoverflow.com/questions/8842753/hyperion-essbase-connection-in-ssis

    Some of the options seem to have been discontinued, but there is an answer that shows how to connect via C# and AdomdDataReader (that the question asker says solved his problem).

    So in the interim until an official solution is released, if you REALLY needed to connect to Essbasefrom from PowerBI, would it not be an option to use the approach shown in the example, and then wrap that either in OData or SQLCLR so it could be called from PowerBI?

    http://www.sqlservercentral.com/stairway/105855/

    Eric Vogelpohl's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:17:12

    RE: Hyperion ESSBASE

    We are also using Essbase in support of Hyperion financial modules. Please provide a connector as our global financial data is not accessible and is this is a significant Power BI business use case.

    Eric Vogelpohl's profile image Profile Picture

    Power BI Ideas Admin on 05 Jul 2020 22:16:39

    RE: Hyperion ESSBASE

    Essbase largely used in our organization. Integrating Powerbi to Hyperion / Essbase would be big +