MYOB Power BI Connector
SyncTools syncs MYOB to your own database on an automated schedule. No API rate limits. No OData middleware. Connect Power BI, Tableau, or any BI tool that speaks SQL.
- Supports MYOB Business and MYOB Advanced
- Flat $50/month — unlimited rows, no overages
- Works with AU and NZ MYOB accounts
No credit card required. Setup in under 15 minutes.
Trusted by Accounting and Finance Teams.
There is no official native MYOB Power BI connector. The main third-party option, OdataLink, still queries the live MYOB API at refresh time — so MYOB's API rate limits still apply.
OData middleware, gateway requirements, and API quotas make direct-to-API approaches unreliable for AU and NZ finance teams running serious reporting workloads. SyncTools moves your MYOB data into a database you own first — Power BI then connects via SQL with none of those constraints.
Why Native MYOB Power BI Options Fall Short
MYOB doesn't offer an official Power BI connector. The main third-party option in the AU/NZ market is OdataLink — a middleware connector that exposes MYOB data via OData endpoints that Power BI can query. At first glance, this seems like a solution. In practice, it introduces its own set of problems for finance teams with meaningful transaction history.
OdataLink still queries the live MYOB API. OdataLink is a pass-through middleware — when Power BI refreshes, OdataLink calls the MYOB API on your behalf. This means MYOB's API rate limits still apply. A Power BI report pulling invoices, bills, contacts, bank transactions, and chart of accounts data can exhaust your MYOB API quota on a single refresh. Teams running multiple reports, multiple companies, or refreshing on a tight schedule hit these limits routinely — resulting in partial data, timeout errors, or dashboards that silently stop updating.
OData is slower than SQL. Power BI's OData connector translates DAX and Power Query operations into OData calls — a query language that is less expressive and slower than SQL. Reports that would run in seconds against a SQL database can take minutes over OData, especially for large datasets. Finance teams with years of MYOB transaction history notice this immediately.
No scheduled cloud refresh without a gateway. Power BI Service cannot reach the MYOB API directly for scheduled refresh. You need an on-premises data gateway installed on a machine that stays online. This is especially frustrating for AU and NZ teams who run cloud-first tooling and don't want to maintain on-premises infrastructure just for BI refresh.
MYOB Advanced and MYOB Business have different APIs. MYOB Advanced (built on the Acumatica platform) uses a different API than MYOB Business. If your organisation has a mix of MYOB editions — or is migrating between them — direct API connectors require separate configuration for each. SyncTools handles both in a unified sync, writing to the same database schema regardless of which MYOB edition you're running.
SyncTools eliminates all of these problems. It syncs MYOB data into a database you own on an automated schedule. Power BI then reads from your database via its native SQL connector — no API calls at refresh time, no rate limits, no OData middleware, and no gateway required for cloud-hosted databases.
How SyncTools Works with MYOB
Three steps. No ODBC drivers. No OData middleware. No custom queries on day one.
Architecture
Connect MYOB
Connect your MYOB Business or MYOB Advanced account via OAuth. SyncTools never stores your MYOB password. Works with AU and NZ MYOB accounts across all supported editions.
Choose your database
Bring your own PostgreSQL, MySQL, SQL Server, or Azure SQL instance — or use the SyncTools-hosted database for zero infrastructure overhead. SyncTools creates the schema automatically and runs the initial historical sync. No DBA required.
Connect Power BI
Point Power BI Desktop or Power BI Service at your database using the built-in SQL Server connector. Scheduled refresh runs against your database — not the MYOB API. No gateway required for Azure SQL or cloud-hosted databases. No OData connector needed.
What MYOB Data Syncs to Your Database
SyncTools syncs the MYOB financial data your reporting needs — structured into query-ready tables with header and line-item detail. No raw API responses. No JSON to parse.
Accounts Receivable
- Invoices (header + line items)
- Payments received
- Credit Notes
- Contacts (customers)
Accounts Payable
- Bills (header + line items)
- Purchase Orders
- Supplier Payments
- Contacts (suppliers)
Banking
- Bank Transactions
- Bank Accounts
- Bank Transfers
General Ledger
- Chart of Accounts
- Tax Codes
- Journal Entries
Inventory
- Items
- Inventory Adjustments
- Stock on Hand
Sales & Purchasing
- Sales Orders
- Quotes
- Purchase Orders
Line-item detail included. SyncTools syncs both invoice and bill headers and their line items — giving you row-level reporting on quantity, unit price, account code, and tax code across every MYOB transaction. This level of detail is unavailable through OData middleware approaches without complex query workarounds.
MYOB Business and MYOB Advanced have different data models. SyncTools handles the mapping per edition — the same database schema works across both, so you can consolidate multi-company MYOB reporting without custom ETL work.
Sync MYOB to the Database You Already Use
Most alternatives lock you into proprietary middleware or data warehouses. SyncTools syncs to the database you already run, or gives you a hosted option if you don't have one.
Key differentiator: OdataLink exposes MYOB data via OData — Power BI still queries live MYOB APIs at refresh time. SyncTools pre-syncs your MYOB data into a real SQL database. Power BI reads SQL — no live API calls, no rate limits, no OData query language to learn.
PostgreSQL
Most popular open-source DB
Fully supported. Ideal for AU and NZ teams running Postgres in AWS Sydney, Google Cloud, or on-premises. SyncTools creates and manages the schema automatically.
MySQL / MariaDB
Common in existing infrastructure
Supported natively. If your stack already runs MySQL — common in hosting environments and ecommerce backends — SyncTools writes directly into it.
SQL Server
Enterprise environments, Power BI's native source
Sync MYOB to SQL Server and connect Power BI using its built-in SQL Server connector. No ODBC setup. No OData middleware required.
Azure SQL
Cloud-first Microsoft stack
For AU organisations on Azure. Sync MYOB to Azure SQL and connect Power BI Service using the managed SQL connector — no gateway required for cloud-to-cloud connections.
SyncTools-Hosted Database
No infrastructure to manage. SyncTools provisions a dedicated database for your organisation and keeps it running. Ideal for AU and NZ teams that want zero DevOps overhead. Power BI connects via the hosted database's SQL endpoint — no gateway required.
If your database isn't listed, contact us — we're expanding support.
Why Database Sync Beats OData Middleware
The database-first architecture isn't a workaround. It's how finance teams run BI at scale — and the reason their dashboards stay fast and reliable when API-dependent connectors fail.
Reliability
No MYOB API timeouts. No OData query failures. No dependency on MYOB's API uptime or rate limits. Your data is in your database — Power BI reads it even if MYOB has an outage or enforces a quota mid-refresh.
Performance
Power BI queries a local or cloud database via native SQL, not a live API through OData middleware. No daily API quotas. No throttling. Reports open in seconds, not minutes — regardless of how many transactions your MYOB account contains.
Flexibility
Once your MYOB data is in a database, any BI tool works — Power BI, Tableau, Metabase, Looker, or custom SQL. Switch tools without re-syncing. Zero platform lock-in and no OData query language to maintain.
One-way sync guarantee: SyncTools reads data from MYOB and writes to your database. It never writes data back to MYOB — your accounting records are never at risk.
If you also use QuickBooks Online, Xero, Sage, NetSuite, Dynamics 365 Business Central, or Zoho Books, SyncTools can sync all of them into the same database — giving you a unified reporting layer without duplicate BI infrastructure. See the QuickBooks Power BI Connector, Xero Power BI Connector, Sage Power BI Connector, NetSuite Power BI Connector, Dynamics 365 Power BI Connector, and Zoho Books Power BI Connector pages for details.
Flat $50/Month. Unlimited Rows.
No per-seat pricing. No row-volume overages. Your price doesn't change whether you have 1,000 invoices or 1,000,000.
SyncTools — Per Company
- All MYOB entities — AR, AP, Banking, GL, Inventory
- All supported databases — PostgreSQL, MySQL, SQL Server, Azure SQL
- SyncTools-hosted database option included
- Automated sync — hourly, daily, or custom schedule
- Unlimited rows — no overage fees
- QuickBooks, Xero, and Sage support included
Competitors charge by row volume or require annual contracts. At $50/month flat, your cost doesn't scale with your MYOB transaction history.
Trusted by Teams Worldwide
Thousands of accounting firms and finance teams rely on SyncTools to streamline reconciliation and save hours every month.
Customers who are Trusting Us
Haider Ali
Business Owner
"Excellent app. Very easy to work with. Very knowledgeable, understanding, and open to any requests."
Tom Brookes
Finance Director
"Best in class. If you use Linnworks and Xero, SyncTools is a phenomenal tool, far superior to any alternative we've tried."
Deborah Whitfield
Customer
"I recently installed SyncTools and it is easy to use. The team worked quickly, kept me informed, and now everything runs smoothly."
Heather Cook
Customer
"Best Xero connector on the market. Excellent customer support and continuous development from an app that does exactly what it says."
Harvey Uppal
Customer
"AWESOME: Excellent tool and has saved us so much time. Credit to the support team for being so helpful in setup and post-setup."
Geoff Ainsworth
Customer
"Excellent tool: Does what it says and connects seamlessly & if you have any issues the support is amazing!"
Nirav Khiroya
Customer
"Fantastic support: The team has always been diligent and proactive about fixing any bugs that arise. Would highly recommend them."
Robert Morris
Customer
"Have been using the Linnworks Xero connector for a couple of years now. It is very reliable and the developers are keen to improve it."
Connie Sturman
Customer
"I just looked in the connector and it looks like they were able to get the purchase orders synced... thank the team for us. Thank you for your help."
Frequently Asked Questions
How do I connect MYOB to Power BI?
Does MYOB have a native Power BI connector?
What is OdataLink and why does SyncTools approach it differently?
Does SyncTools support MYOB Advanced and MYOB Business?
What MYOB data entities does SyncTools sync?
Does SyncTools work with MYOB AccountRight?
Ready to Connect MYOB to Power BI Without the Limits?
SyncTools syncs MYOB Business and MYOB Advanced to your own database on an automated schedule. Connect Power BI, Tableau, or any BI tool via SQL. Flat $50/month, unlimited rows.
Setup in under 15 minutes. No credit card required for trial.