Finance, ERP and payments · data source guide

NetSuite data in Power BI

NetSuite is a cloud ERP: general ledger, subsidiaries, sales orders, inventory and purchasing in one system. Power BI reporting from NetSuite usually means a consolidated finance pack across subsidiaries plus order and inventory pages for operations.

Connector status

No connector of its own in Microsoft's list

NetSuite has no connector of its own in Microsoft's index. Oracle NetSuite offers SuiteAnalytics Connect, which provides ODBC access, and Power BI's ODBC connector is listed; saved-search exports and third-party connectors are the other paths.

Checked against Microsoft Learn's Power Query connector list on 5 November 2026. Connectors change; check the list before you build.

How to get NetSuite data into Power BI

In order of preference for a report that refreshes on its own.

  1. 1

    SuiteAnalytics Connect via ODBC

    If your account has SuiteAnalytics Connect, install the NetSuite ODBC driver, create a DSN and use Get data → ODBC. Scheduled refresh in the Service then needs an on-premises data gateway with the same driver installed.

  2. 2

    Saved searches for focused extracts

    Build a saved search for the records you need (for example transaction lines by period) and export it to CSV for a first version.

  3. 3

    Third-party connectors

    Certified third-party connectors in Microsoft's list may cover NetSuite; check coverage, licensing and refresh limits with the vendor.

  4. 4

    Model subsidiaries and currencies first

    Decide whether reports use consolidated amounts in the parent currency or subsidiary amounts; NetSuite holds both, and mixing them is the most common error.

Typical NetSuite KPIs

Table and column names in the DAX are illustrative: rename them to match your model.

Consolidated revenue

Revenue in the parent currency across subsidiaries.

DAX
Revenue (Consolidated) = CALCULATE ( SUM ( TransactionLines[ConsolidatedAmount] ), Accounts[Type] = "Income" )

Order backlog

Sales orders not yet fulfilled or billed.

DAX
Backlog = CALCULATE ( SUM ( SalesOrders[OpenAmount] ), SalesOrders[Status] IN { "Pending Fulfillment", "Pending Billing" } )

Inventory turns

Cost of goods sold divided by average inventory value.

DAX
Inventory Turns = DIVIDE ( [COGS L12M], [Avg Inventory Value] )

Days payable outstanding

Payables divided by average daily cost of goods.

DAX
DPO = DIVIDE ( [AP Balance], DIVIDE ( [COGS L90D], 90 ) )

Budget variance by subsidiary

Actual against budget per subsidiary.

DAX
Var to Budget = [Actual] - [Budget]

Modelling notes for NetSuite

Templates for NetSuite data

Free page layouts with a background, theme JSON and PBIP project. Swap the sample tables for your own queries.

Power BI visuals for Supply Chain · More by department: Finance templates · Supply chain templates

Visuals for NetSuite KPIs

Chart types that suit these KPIs, with data shapes and example prompts.

NetSuite and Power BI: questions

Is there an official NetSuite connector for Power BI?

Not in Microsoft's Power Query connector index (checked 5 November 2026). SuiteAnalytics Connect over ODBC is the common route.

Do I need a gateway for NetSuite?

With the ODBC route, yes: the driver runs on a machine with the on-premises data gateway installed, which the Service uses for scheduled refresh.

Related data sources

Other sources teams often combine with this one.

NetSuite is a trademark of its owner. Product names are used only to describe compatibility; VizForge is not affiliated with, endorsed by or sponsored by the owner or by Microsoft.

Design the NetSuite report page first

Lay out KPI cards and visual slots in the free Design Studio, then export the background, theme JSON and a PBIP project to bind to your data.

Open in the design studio →Browse templates

The design studio for Power BI. Free, in your browser, no sign-up.