Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Power BI SAP Connection

  • 1.  Power BI SAP Connection

    Top Contributor
    Posted 24 days ago
    Edited by Vishesh Jain 24 days ago
    Hello everyone,

    I wanted to know, if I can connect to SAP and extract data from it in to PBI.

    The data in SAP is on the client's premise and I want to access if from my workplace and do everything PBI related stuff here, i.e. ELT and creation of dashboard etc.

    Also, I want to set up scheduled refresh from my workplace as well.

    Please can someone guide me, if this can be done and how.

    Thank you,

    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------
    Conference-PBI_200x200


  • 2.  RE: Power BI SAP Connection

    Bronze Contributor
    Posted 23 days ago
    What is the version of SAP that client is using? If they are using SAP HANA, then they need to create queries to  give you the access. Then use SAP connector  "GET DATA" to connect.

    ------------------------------
    Mohamed Ibrahim
    ------------------------------

    Conference-PBI_200x200


  • 3.  RE: Power BI SAP Connection

    Top Contributor
    Posted 23 days ago
    Hi @Mohamed Ibrahim,

    Th​ank you for responding.

    I don't have knowledge about SAP so want to know more about it. As of now I don't know what version is the client using.

    What all versions of SAP can PBI connect to and is there any version that PBI CANNOT connect to.

    When you say 'create queries', will it be like a SQL query and will I have access to Power Query to do ETL.

    My apologies that my questions are a bit open and probably do not provide a whole lot of information.

    Whatever information you can spare will be helpful.

    Thank you,


    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------

    Conference-PBI_200x200


  • 4.  RE: Power BI SAP Connection

    Bronze Contributor
    Posted 23 days ago
    It will be better to talk to the IT team of the client side. If the IT team does not have idea talk to the SAP vendor of the client. SAP has multiple versions like ECC, HANA etc. Also for getting access to SAP one needs SAP certified connector. Tableau and Qilk Sense has connectors but Power BI does not. So you need to use ODCB connector and write queries to expose SAP data.

    ------------------------------
    Mohamed Ibrahim
    ------------------------------

    Conference-PBI_200x200


  • 5.  RE: Power BI SAP Connection

    Top Contributor
    Posted 23 days ago
    Hi @Mohamed Ibrahim,

    Please can you tell me, once I am able to connect to the SAP data, will I be able to ETL in Power Query?

    Thank you for all the information.​

    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------

    Conference-PBI_200x200


  • 6.  RE: Power BI SAP Connection

    Bronze Contributor
    Posted 23 days ago
    The way we did was to have a interim SQL server. SAP will push the data to a SQL server and Power BI takes data from there. You might need to check with others as well in case.

    ------------------------------
    Mohamed Ibrahim
    ------------------------------

    Conference-PBI_200x200


  • 7.  RE: Power BI SAP Connection

    Posted 23 days ago
    Hi Vishesh,

    Find out product they are using? SAP Business One, ECC etc. There are loads of applications and identifying the right product will narrow it down.
    Also find out what Database does it sit on - SQL OR HANA.

    Once you have this then there a few options that might work,
    1. Connect PowerBI via ODBC connector to expose the data
    2. We work with SAP through our product ZAP (ETL/DataWarehouse) and the bring the information seamlessly to PowerBI. You can see more details here - https://www.zapbi.com/product-features-in-depth/

    Regards,
    Rohit


    ------------------------------
    Rohit Kanwara
    UK&I Sales Executive
    Zap Technology Limited
    ------------------------------

    Conference-PBI_200x200


  • 8.  RE: Power BI SAP Connection

    Top Contributor
    Posted 23 days ago
    Hi Vishesh !

    As mentioned by other people here you first need to identify what's the source SAP HANA or older version SAP.

    There was a time when SAP uses other RDBMS to store data but with HANA it stores data within its own RDBMS, anyone can correct me on this.

    Now as in SQL we have SQL Database & we have SSAS analysis service, in SAP we have Cubes as well. Most probably if the client already has a DW they will expose those to you.

    These cubes will have some limitations either you import them or query them directly. Both have different scenario.

    Please get requirements from the client what they want to visualize, this will help you deciding the route.

    Regards,


    ------------------------------
    Hasham Bin Niaz
    Director Data & Analytics
    Karachi, Pakistan
    ------------------------------

    Conference-PBI_200x200


  • 9.  RE: Power BI SAP Connection

    Top Contributor
    Posted 22 days ago
    If database is SAP HANA, then you need to create Cubes using SAP Studio that will expose data for you. Once you create related data , then you need to ask SAP Admin to give you IP/Server Name and port for that SAP Cube that will connect to you with any reporting tool.
    When he will provide you that IP/Port and userid/pwd then you need to download SAP Connector/Driver from SAP site (It will require SAP ID I think).
    After that you need to configure ODBC connection from that machine to SAP Cube using this Driver.
    Once you done all above, go to your Power BI Report and then connect with SAP HANA data base with same server/ip and user/pwd. You will be able to import data in PBI and you can schedule refresh accordingly...

    A little lengthy description but I hope this will help you.

    ------------------------------
    Farhan Ahmed
    Senior Business Intelligence Consultant
    karachi
    3452523688
    ------------------------------

    Conference-PBI_200x200


  • 10.  RE: Power BI SAP Connection

    Top Contributor
    Posted 22 days ago

    Thank you everyone for your responses.

    Got some good information.

    I will get in touch with the client and get more information, but as of now all of your responses have provided me information to get me started.

    I will get back once I have more information or if I get stuck somewhere.

    Thank you,



    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------

    Conference-PBI_200x200


  • 11.  RE: Power BI SAP Connection

    Top Contributor
    Posted 20 days ago
    Hello again everyone,

    Just wanted to share the information that the client is using SAP ECC version.

    So any further information, will be helpful.

    Thank you,

    ------------------------------
    Vishesh Jain
    Owner
    VR Construction
    ------------------------------

    Conference-PBI_200x200


  • 12.  RE: Power BI SAP Connection

    Bronze Contributor
    Posted 20 days ago
    In that case, from my experience, the way forward is to push the data from SAP into  staging tables (intermediary db) and take data from there.

    ------------------------------
    Mohamed Ibrahim
    ------------------------------

    Conference-PBI_200x200