Planning

Get Involved. Join the Conversation.

Topic

    Allie Stokes
    Power BI Connection to PBCS/EPBCSAnswered
    Topic posted April 16, 2019 by Allie StokesGreen Ribbon: 100+ Points, tagged Analysis, EPBCS, Financial Planning, PBCS, Planning, Reporting 
    143 Views, 3 Comments
    Title:
    Power BI Connection to PBCS/EPBCS
    Summary:
    PBCS direct data connector to BI tools
    Content:

    Hi,

    Does anyone know how to connect PBCS/EPBCS directly (not through SmartView ad-hoc form) to BI tools, such as PowerBI?

    There is a build in Essbase connector (currently in beta stage) in Power BI will that work for PBCS?

    Thank you,

    Allie

    Best Comment

    Navan Mehra

    PBCS/EPBCS offer REST APIs and export data API should be able to help you pull data in JSON format. Few things to take care:

    • It is not a straight forward pull like any other data source
    • You need to use DAX scripting to call the POST HTTP request rather than GET
    • The returned response is a nested JSON which would further require some massaging, but its doable
    • You need to think of possible datasets and create the Export requests

    The benefit would be you would be able to pull real time data from PBCS/EPBCS

    Comment

     

    • Scott Williams

      My understanding is the Power BI Essbase connector is for connectivity to on premise Essbase.

      It may work with OAC, but I doubt it would work with EPBCS/PBCS.

    • Gary Crisci

      Essbase is not exposed for PBCS so you won't be able to connect it unless they develop an adapter. So far there are limited tools that can connect to PBCS besides SmartView and EPRCS. There's away to extract PBCS to RPD and use Data Visualization, but it is not a great integration because the RPD will flatten the hierarchies.

       

       

    • Navan Mehra

      PBCS/EPBCS offer REST APIs and export data API should be able to help you pull data in JSON format. Few things to take care:

      • It is not a straight forward pull like any other data source
      • You need to use DAX scripting to call the POST HTTP request rather than GET
      • The returned response is a nested JSON which would further require some massaging, but its doable
      • You need to think of possible datasets and create the Export requests

      The benefit would be you would be able to pull real time data from PBCS/EPBCS