MS Power Bi for SAP Business One

Power BI is a tool that allows you to analyse and visualise data in the simplest possible way. It is a collection of tools that is based on a service in the cloud and thus also enables the distribution of data. Versino has now made Power BI usable for SAP Business One and implemented a special integration concept.

The Power Bi Desktop

The Power BI Desktop is a Windows client with which the report creator works.

Features of :

Very intuitive operation
Access for the report recipients is in the cloud, without the data necessarily being stored in the cloud. cloud lie
Excellent integration into the Microsoft world
Simple and flexible Licensing via a subscription
Secure data transmission : Only results, no basic data
Local data can be imported if required
Access and interaction with Data Warehouse
MS SQL Server Analysis Services can be used seamlessly
With the Versino integration Access to SAP Business One
Power BI for SAP Business One soon also for SAP HANA

With this he can:

Read in data and / or connect data sources
Model and transform data
Create reports
Visualise data
Provide data via Power BI Service

The Power Bi Cloud Service

The reports created can then be shared via the cloud service.

With this you can:

Viewing dashboards and reports
Create and share dashboards
Setting up gateways

Once your reports have been created, they are made available via the Power BI Service. The Power BI Service is part of the Office 365 family. However, you do not necessarily need an Office 365 subscription to use the Power BI Service.
The user logs in via the browser with their access data and sees the reports and dashboards that have been released for them.
However, access is not only possible via the browser, but also via various apps. There is a Windows 10 app or apps for mobile platforms to enable convenient access via mobile and tablet.

Power BI scenarios

Power BI without connection to a DATA warehouse

Direct connection to data sources
Several independent data sources can be combined
Flexible modelling and transformation directly in Power - Bi

Power BI as a frontend to a data warehouse

Connection to a data warehouse server (SQL Server Analytics or SAP Business Warehouse)
No simultaneous connection to other data sources
Modelling and transformation takes place in the data warehouse
Power BI serves as visualisation and reporting frontend

Power BI for SAP Business One Integration

Access to Dynamic Data Views via Power BI. Preconfigured data containers that hold all content for specific scenarios
Extendable through customised structures

SAP B1 blog