We're using SAP Business One as an ERP System, and we want to implement Microsoft Power BI project with SAP Business One, that's will be integrated with SAP Business One (SQL Server Database), but unfortunately, I didn't find anything on the internet about if SAP authorized use Power BI as analytic tool, that's will not be integrated directly with SAP Business One but with SQL Server.
Thanks in advance.
I have the same question as you have. Did you have received a solution foor getting data out of SAP Business one to use trhe data with Power BI?
Hi JBoham, 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;
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.
Why using MS Power BI and don’t use SAP BI (Crystal Reports-CR)?!
Cons of Crystal Reports-CR
Pros of Microsoft Power BI
Pros and Cons of SAP Crystal Reports
For that using MS Power BI as Analytical Tool beside SAP Business One as ERP System, is legal and authorized by SAP itself.
Doesn’t affect the performance of SAP Business One or the Database.
for example; we have 10 active users on Power BI service who get their required information in most professional way, with total monthly cost $100 !!!, but if we implement SAP Crystal Report that would cost us at least $7,500 initial cost beside the annual fees, and overall, you get your information in bad way, just from your work-machine, can’t reach it on the go, difficulties handling with the interfaces.
It’s really cool to have the biggest brands in the world (Microsoft – SAP) work together side by side to provide us whatever we want on whichever we need.
Hope this article was helpful.