MS Power Bi

The integration of MS Power Bi with SAP Business One creates completely new possibilities for data analysis of SAP B1 data.

sap-blog
Your important data everywhere

Power Bi lets you access all of your company's critical data from SAP Business One, anywhere. Whether locally via SQL Server Analysis Services or in the cloud with Azure Analysis Services, the right analytics are available for all your data.

puzzle-1
Intuitive data preparation

With Power Bi you get an intuitive and comprehensive tool for preparing, evaluating and visualizing your data from SAP Business One. Combine different data sources, enrich data and present this data in many different ways.

eye-1
Locally or/and in the cloud

Power Bi lets you access all of your company's critical data from SAP Business One, anywhere. Whether locally via SQL Server Analysis Services or in the cloud with Azure Analysis Services, the right analytics are available for all your data.

Broad integration

Interactive reports based on your SAP Business One data can be accessed from SAP B1, web, mobile, or from your Office 365 account. The Power BI Embedded service also allows integration with your specific application.

FUNKTIONEN

What MS Power Bi can do.

Intuitive and user-friendly tools for structuring, modeling and visualizing data. Without the need for deep knowledge of SQL or database structure. In addition: Integrated in SAP Business One, callable and editable. With alarm function to be able to react quickly to changes.

Power BI consists of various components. These are different services, gateways and tools, some of which are provided in the cloud and some of which are operated on end devices. The most important components of Microsoft Power BI include:

Power BI Desktop

The Windows-based desktop application for PCs or notebooks for transferring, transforming and modulating data and generating reports from it.

Power BI (Service) 

Power BI as software as a service from the cloud (originally called Power BI for Office 365)

Power BI Mobile

Mobile apps for iOS, Windows and Android

Power BI Gateways

Interfaces for the integration of external data.

Power BI Embedded

REST API to embed reports, dashboards or visualizations in other applications (e.g. SAP Business One).

Power BI Report Server

For the storage and management of Power BI reports.

 

The sources that can be used for a data analysis with Power BI are manifold. These can be databases of all kinds, web services that pass on data records, or even individual Excel files that are imported.

The local or cloud-based sources are connected via various gateways. Power BI already comes with a large number of connectors. SAP HANA, for example, is also supported. However, you can also develop your own connectors to expand the basis of the data analysis.

Questions about MS Power Bi?

Feel free to contact us by phone or e-mail.