Skip to Content

Is Microsoft Power BI authorized to be used by sap?

Hello Experts;

We're planning to use Microsoft Power BI to be integrated with SAP Business One (SQL Server Database) as Analytic Tool, you know that we'll get the required query and use it inside of MS Power BI, but we do want to know if what we’re planning to do is legal, does SAP authorize using this third-party tool with its technology - for its side, does integrate this tool with database affects (SAP and its SQL Database) performance to be slower or functioning improperly?

Thanks in advance.

Kenan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 16 at 12:19 PM

    Hi everyone!, kindly find below what I've got about this issue.

    We’re using Microsoft Power BI (Business Intelligence) as a professional Analytic Tool, we connect it directly to the SQL Database through specific required queries we want, regarding we’re using SAP Business One with SQL Server not HANA (currently), but we do want to know if what we’re doing is LEGAL, does SAP authorize using this third-party tool with its technology??, does integrate this tool with database affects (SAP Business One – SQL Database) performance to be slower or functioning improperly?

    First of all, is there any partnership between SAP and Microsoft?

    Microsoft and SAP Join Forces to Give Customers a Trusted Path to Digital Transformation in the Cloud

    From the beginning of the start, Microsoft and SAP has always worked together in amazing way, their cooperation appears in;

    • SAP Business One (SQL Server) > Microsoft SQL Server
    • SAP Business One (HANA Server) > Microsoft Azure. Here!
    • SAP Business Objects > Microsoft Excel, Microsoft Power Query, Microsoft Pivot Tables
    • SAP Business Objects > Microsoft Power BI. Here!
    • SAP Business ByDesign > Microsoft Power BI. Here!
    • SAP Business Warehouse System > Microsoft Power BI. Here!

    For more information; SAP-Microsoft Partnership
    and kindly find attached the Microsoft BI-SAP white paper.
    also you may find attached the complete presentation from Microsoft side about connecting with SAP.

    matter where your data lives or what form it’s in, you get a holistic view of the key metrics for your business.


    Hope this was helpful.

    many thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 12 at 04:32 PM

    I don't think it is ever required to have an SAP authorization. The only problem is: 3rd party programs will access your database directly and might cause issues to your system. You have to be certain that they will not modify or even cause performance issues on your system.

    You also might want to restrict the access to external tools and users, so you probably want to create views over the tables you want to use. This will prevent direct access to the database and tables.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 16 at 05:01 PM

    Power BI works with Sql server. I have tried out till 2014 version

    I believe there is revision in usage of CALS license from Sql -2016 version.

    You can either use SSAS or write query to extract data into power bi.

    If you’ve use query method, then it does have impact on sql performance. So I suggest you use sql query-import method and don’t use direct query method.

    There is option to schedule data refresh from the Power BI Gateway for both on premis and cloud- using azure..

    If you are going with on- premis, Use Power BI gateway(instead of personal power bi gateway) for data refresh scheduling.

    Keep the query simple, create the logic’s and data slicing using the Dax functions as this will reduce the load on sql server.

    Power BI has been releasing new feature every month. If you are familiar with R Script you can further customize visualizations.

    Hope the above info helps you.

    Add comment
    10|10000 characters needed characters exceeded