How Versino Power BI Add-on for SAP Business One connects to SAP Business One
SAP Business One add-on with prebuilt Power BI datasets
Per the vendor description, the add-on provides datasets and dashboards over Business One data without database expertise. Which tables or views it reads, and whether it needs a gateway to a SQL Server or SAP HANA back end, depends on your deployment, so confirm that with Versino before sizing.
Power BI Desktop, Service and on-premises data gateway
Business One on-prem keeps its data in SQL Server or SAP HANA inside your network. Scheduled refresh in the Power BI Service normally goes through an on-premises data gateway, which is a general Power BI pattern rather than something specific to this add-on.
What data moves
| From | To | Data | When |
|---|---|---|---|
| SAP Business One | Power BI dataset | Sales, purchasing, inventory and finance transactions and master data | Scheduled dataset refresh |
| Power BI dataset | Dashboards and reports | Measures such as open orders, stock value and receivables ageing | Report open or refresh |
| Business One user-defined fields | Power BI dataset | Custom fields your team added to documents and items | Dataset extension by your report author |
| Power BI report | Business One user | Drill-through to document numbers for lookup in Business One | User clicks through a visual |
Setting it up
- 1Confirm version and databaseRecord your Business One version, whether you run SQL Server or SAP HANA, and ask Versino for the supported matrix.
- 2Choose the Power BI licensing modelDecide between Pro, Premium per user or capacity licensing based on how many people view reports.
- 3Install the add-on and connectFollow the vendor install steps and use a read-only database login so reporting can never write to the ERP.
- 4Set up the gatewayIf the database is on-prem, install the on-premises data gateway on a server that can reach it and register it in the Power BI Service.
- 5Validate the numbersCompare a handful of dashboard figures to standard Business One reports (open sales orders, inventory valuation) before anyone relies on them.
- 6Add user-defined fieldsExtend datasets with the UDFs your business actually uses, such as customer segment or project code.
- 7Schedule refresh and ownershipSet refresh times outside month-end posting peaks and name someone who owns failures.
What usually breaks
- !Dashboard totals disagree with Business One reports because of different treatment of cancelled, draft or credit-note documents. Reconcile definitions before launch.
- !User-defined fields and user-defined tables are not in a standard dataset unless someone adds them, so custom processes look empty in reports.
- !Refresh runs against the live database during working hours and slows posting on a small SQL Server. Schedule it off-peak or point it at a replica.
- !Row-level security in Power BI is separate from Business One authorisations, so a manager can see data in a dashboard that their ERP role would block.
- !Upgrading Business One or the add-on changes schema or datasets and silently breaks custom measures. Re-test after every upgrade.
A private AI layer across both systems
Plain-language questions beyond the dashboards
A private assistant reading Business One directly can answer one-off questions the prebuilt dashboards do not cover, for example which customers have open orders on items below safety stock, and show the query it ran.
Number reconciliation
When a Power BI figure and a Business One report disagree, the assistant can compare both sources and point to the documents that explain the gap.
Draft measures for approval
It can propose DAX measures or dataset changes in plain language for a report author to review, rather than editing the model itself.
Narrative for the month-end pack
It can summarise the dashboards and underlying movements into a draft commentary that a finance lead edits before it goes out.
Try it here, free
SAP B1 Implementation Cost Calculator
Enter users, rates and effort days to see first-year and three-year SAP Business One cost, using your own partner quotes.
When something else fits better
- Business One's own reports, Crystal Reports layouts and query generator are enough for operational lists and many finance reports.
- A custom Power BI model built on SQL views gives full control over definitions, at the cost of build and maintenance time.
- A different BI add-on with budgeting and consolidation, such as Solver BI360, fits teams that need planning as well as reporting.
Frequently asked questions
Do I need database skills to use it?
The vendor positions the add-on as removing that need for standard reporting, because the datasets and dashboards come prebuilt. You will still want someone who understands your chart of accounts and custom fields to validate numbers and extend the datasets.
Does it work with Business One on-prem?
Business One data lives in SQL Server or SAP HANA, and Power BI can reach on-prem sources through a data gateway. Confirm the exact supported versions and connection method with Versino for your deployment. Confirm the details with the vendor for your version and deployment before committing.
Can it write back to Business One?
Power BI is a reporting layer, and the add-on is described as datasets and dashboards, so treat it as read-only. Use a read-only database login so the point is enforced by permissions, not by trust. Confirm the details with the vendor for your version and deployment before committing.
Where does AI fit alongside Power BI?
Dashboards answer the questions you planned for. A private assistant over Business One can answer the unplanned ones in plain language, run on your own servers, and leave Power BI for governed, shared reporting. Confirm the details with the vendor for your version and deployment before committing.
Pairing documented at sap-b1-blog.com/en/ms-power-bi-for-sap-business-one/ . Versino Power BI Add-on for SAP Business One is a product of Versino; Netray is independent and not affiliated with either vendor.