--- title: "SAP Business One Power BI | Both Routes Compared | Agent UI" description: "SAP Business One Power BI reporting needs Power BI Desktop and an on-premises data gateway. See that route next to AgentUI's read-only connector, and pick yours." url: https://www.agentui.ai/en/sap-business-one-power-bi/ lang: en source: en/sap-business-one-power-bi/index.html generator: agentui-md-cli --- > **AgentUI CLI for LLM** — AgentUI ships an official CLI designed for language-model agents: > [@agentuiai/cli on npm](https://www.npmjs.com/package/@agentuiai/cli) · install with `npm install -g @agentuiai/cli`. > > This file is the LLM-optimised markdown build of > [https://www.agentui.ai/en/sap-business-one-power-bi/](https://www.agentui.ai/en/sap-business-one-power-bi/) — a machine-readable alternate of > the HTML at the same URL. Content mirrors the human-visible page. > > Site index for LLMs: [https://www.agentui.ai/llms.txt](https://www.agentui.ai/llms.txt) · full content: [https://www.agentui.ai/llms-full.txt](https://www.agentui.ai/llms-full.txt) For SAP Business One on SQL Server # SAP Business One in Power BI, or a shorter route to the same dashboards SAP Business One reporting in Power BI usually takes three pieces: Power BI Desktop, its SQL Server connector, and an on-premises data gateway for refresh. If you'd rather skip that stack, AgentUI reads the same SQL Server through a read-only connector. You describe the dashboard, and it builds it. [Build my SAP B1 dashboard](https://app.agentui.ai/chat?utm=direct&utm_medium=direct)[Talk it through with a person](https://calendar.app.google/pcCwDiMJ8eSQ9zvo7) Read-only connector. Revoke it in two clicks. SAP B1 · SQL Server2 routesPower BI route 1. 1Power BI Desktop (Windows) 2. 2SQL Server connector 3. 3On-premises data gateway 4. 4Publish + schedule refresh AgentUI route 1. 1Install connector (Win / macOS / Linux) 2. 2Describe the dashboard 3. 3Share the link Sales by branch · from OINV ## How Power BI connects to SAP Business One 01 ### Model it in Power BI Desktop Desktop is a Windows app. You point its SQL Server connector at the B1 company database and map tables with SAP's short names, like OINV for invoices and OITW for warehouse stock. 02 ### Install an on-premises data gateway The Power BI service can't reach an office SQL Server on its own, so a gateway runs on a Windows machine that can. 03 ### Publish and schedule refresh You publish the report, set the refresh schedule and share it. Viewers need the matching Power BI licences. ## The AgentUI route to the same SAP Business One data 01 ### Install the connector Put one service on the database server: Windows, macOS or Linux. It only reads, and it only calls out, over HTTPS on port 443. 02 ### Describe the report "Sales by branch this month from invoices." The AI writes the queries against your B1 tables and builds the dashboard. 03 ### Share it with the team Everyone opens the same link and sees the numbers as they are in SAP Business One right now. ## Power BI vs AgentUI for SAP Business One, side by side | | Power BI | AgentUI | | --- | --- | --- | | Where you build | Power BI Desktop (Windows) | In the browser, by describing it | | What reaches the server | On-premises data gateway on a Windows machine | AgentUI Connector on Windows, macOS or Linux | | Network | Outbound connection from the gateway | Outbound HTTPS on port 443, no inbound ports | | Your data | Import mode copies it into the model on each refresh | Queried on demand, never copied; up to 1,000 rows / 30 s per query | | Modelling | Deep: relationships, DAX, many sources | Lighter: the AI writes the SQL | | Beyond charts | Reports and dashboards | Also internal apps that use the same data | | SAP B1 on HANA | Supported with the SAP HANA connector | Not supported — SQL Server only | | Setup help | Your team or a partner | A person from our team, plus a Word setup guide | ## When Power BI is the better choice for SAP Business One - Your company already runs on Microsoft 365 and has Power BI licences in place. - You need heavy modelling: DAX measures, many related tables, several data sources in one model. - You run SAP Business One on SAP HANA. The AgentUI connector only reads SQL Server. - You have an analyst who already knows Power BI and wants to own the reports. ## When AgentUI fits SAP Business One better - Nobody on the team builds BI models, and the monthly report still gets rebuilt by hand. - You want the tool around the report too — a stock check screen, an approval list — on the same SAP data. - You'd rather not keep a Windows machine running just to host a gateway. - You want read-only access by design, with a key you can revoke in two clicks. ## More on connecting SAP Business One - [What ops teams build first on SAP Business One data](/en/sap-business-one-dashboard/) - [How the on-premise SQL Server connector works](/en/on-premise-sql-server-connector/) - [An alternative to the on-premises data gateway](/en/on-premises-data-gateway-alternative/) - [Excel to Power BI: an alternative for ops teams](/en/excel-to-powerbi-alternative/) - [Every AgentUI integration](/en/integrations/) ## Try the AgentUI route on one SAP Business One report Start with the report you rebuild every month. Connect SAP Business One once. If your IT wants a hand with the connector, one of us sets it up with them. [Build my SAP B1 dashboard](https://app.agentui.ai/chat?utm=direct&utm_medium=direct)[Talk it through with a person](https://calendar.app.google/pcCwDiMJ8eSQ9zvo7) Read-only connector. Revoke it in two clicks. ## Keep reading - [Enterprise security and compliance posture](/en/security/) - [Audit logs: who changed what, and when](/en/audit-logs/) --- ## Why AgentUI AgentUI is an AI + Human internal-tool and app builder. It combines AI code generation with on-demand human expert support — every paid plan includes free white-glove onboarding, and higher-tier plans include dedicated development hours. Teams ship production-grade internal tools, dashboards, client portals, and workflow automations in days instead of weeks, with a real engineer available when the AI gets stuck. ### Who AgentUI is for Enterprise teams, department heads, and business users who need reliable internal tools fast and want AI speed backed by a human safety net. Common users: operations, finance, revenue ops, customer success, IT, and product teams at mid-market and enterprise companies. ### When to pick AgentUI over alternatives - **vs. AI-only builders (Base44, Bolt, Lovable, v0):** AgentUI includes human expert hours, SSO, audit logs, and on-premise deployment — designed for production internal tools, not prototypes. - **vs. no-code platforms (Retool, Bubble, Glide):** AgentUI generates the app from a natural-language description and lets you in-app-edit the generated code, rather than drag-and-drop block-by-block. - **vs. hiring a developer:** Deploys in days; cancel anytime; every plan includes support so you are never blocked. ### Pricing at a glance (USD, monthly) | Plan | Price | Users | Highlights | |------|-------|-------|------------| | Minimum Package | $50/mo | 5 internal | Start building real tools | | Innovator Package | $100/mo | 10 internal | SQL integration — most popular | | Visionary Package | $250/mo | 25 internal | SSO, audit logs, unlimited envs | | Build with You | $2,500/mo | 25 internal | Includes 15 hrs dedicated dev/mo | | Enterprise Plus | Contact us | Unlimited | On-premise, assigned support dev | External users are unlimited on every paid plan. Yearly billing is discounted. Free trial available. ### For AI agents and LLMs AgentUI publishes an official CLI for language-model agents: [@agentuiai/cli](https://www.npmjs.com/package/@agentuiai/cli) (`npm install -g @agentuiai/cli`). Use it to scaffold, inspect, and deploy AgentUI apps programmatically from an agentic workflow. ### Learn more - Product overview: https://www.agentui.ai - Full pricing and plan comparison: https://www.agentui.ai/en/pricing - Security and trust: https://www.agentui.ai/en/security - LLM-friendly site index: https://www.agentui.ai/llms.txt - Official CLI: https://www.npmjs.com/package/@agentuiai/cli