How to Connect NetSuite to Power BI Using SuiteAnalytics Connect

How to Connect NetSuite to Power BI Using SuiteAnalytics Connect

NetSuite holds your transactional data sales orders, customers, invoices, inventory. Power BI is where most organisations turn that data into dashboards leadership actually looks at. Connecting the two means you can build reports on live NetSuite data without exporting a single CSV. Here is exactly how to set it up from scratch.

Why Connect NetSuite to Power BI?

NetSuite's built-in reports and saved searches are useful but limited. You cannot easily combine NetSuite data with data from other systems, build the kind of visuals stakeholders expect, or refresh a dashboard automatically without someone logging in to re-export a file. Every time leadership wants an updated view, someone has to build a saved search, export it, and rebuild the report by hand.

Once NetSuite is connected to Power BI via SuiteAnalytics Connect, all of that changes. You can pull NetSuite tables directly into Power BI, blend them with your other data sources, build interactive dashboards, and refresh the whole thing on a schedule. It is a one-time setup that permanently improves how your organisation reports on NetSuite data.

How it works in plain English

SuiteAnalytics Connect is NetSuite's built-in ODBC interface. It exposes your NetSuite data as a set of SQL-queryable tables. The ODBC driver sits on your Windows machine and acts as the bridge. Power BI's built-in ODBC connector then reads through that same System DSN, so Power BI sees NetSuite the same way it would see any other ODBC data source.

Prerequisites

Make sure you have all of these before starting. Missing any one of them will block you at a specific step.

1. NetSuite Account : With SuiteAnalytics Connect access enabled
2. NetSuite Permissions : Administrator or role with Analytics access
3. Windows Machine : The ODBC driver is Windows-only
4. SuiteAnalytics Connect ODBC Driver : Downloaded from NetSuite
5. Power BI Desktop : free download from Microsoft
6. Internet Connectivity : Required for the ODBC connection to NetSuite

The Step-by-Step Connection Process

Step 1 : Enable SuiteAnalytics Connect in NetSuite

Before anything else, SuiteAnalytics Connect needs to be enabled in your NetSuite account. This is done through the Company Features settings.

1. Log into NetSuite and go to Setup → Company → Enable Features
2. Click the Analytics subtab
3. Find SuiteAnalytics Connect and check the box to enable it
4. Click Save

If you do not see the Analytics subtab or the SuiteAnalytics Connect option, your NetSuite role does not have the required permission. Ask your NetSuite administrator to enable it or assign you a role that includes SuiteAnalytics access.

Step 2 : Get Your SuiteAnalytics Connect Details

After enabling SuiteAnalytics Connect, you need to find your connection credentials. These are specific to your NetSuite account and are different from your login credentials.

1. Go to Home → Settings
2. Click Set Up SuiteAnalytics Connect
3. Note down all the values on this page you will need them in Step 4

Keep these details secure

Your Account ID, Role ID, Service Host, and credentials are sensitive. Do not paste them into shared documents or screenshots without redacting them first.

Step 3 : Download the SuiteAnalytics Connect ODBC Driver

The ODBC driver is also available from the SuiteAnalytics Connect setup page in NetSuite.

1. On the Set Up SuiteAnalytics Connect page, find the driver download section
2. Download the Windows 64-bit ODBC driver
3. Run the installer and follow the installation steps
4. Once installed, the driver will be available as an option in Windows ODBC Data Source Administrator

Download the 64-bit version

Power BI Desktop on modern Windows is 64-bit. The ODBC driver must match download the 64-bit version. The 32-bit driver will install without errors but Power BI will not be able to see it.

Step 4 : Configure the System DSN in Windows ODBC

A System DSN (Data Source Name) is a saved connection profile that Power BI will use to connect to NetSuite. Setting this up correctly is the most important part of the whole process.

1. Press Windows + S and search for ODBC Data Sources (64-bit) make sure you open the 64-bit version
2. Click the System DSN tab
3. Click Add
4. Select NetSuite Driver 64 Bit from the list and click Finish
5. Fill in the configuration fields using the values from Step 2
6. Give the DSN a clear name for example NetSuite you will select this same name inside Power BI in Step 7

Use System DSN, not User DSN

A System DSN is visible to every user and service on the machine, which matters if you later move the report to Power BI Service through a gateway. Always create a System DSN so the connection is not tied to a single Windows login.

Step 5 : Test the ODBC Connection

Before opening Power BI, confirm the ODBC connection itself is working. This saves a lot of time debugging later.

1. In the ODBC configuration window, click Test Connection
2. Enter your NetSuite username and password when prompted
3. If successful, you will see a Connection successful message
4. Click OK to save the DSN

If the test fails

Double-check the Service Host URL it is the most common source of errors. Make sure there is no trailing slash and the format exactly matches what NetSuite shows on the setup page. 

Step 6 : Install Power BI Desktop

If you do not already have Power BI Desktop installed, here is how to get it. It is free.

1. Go to powerbi.microsoft.com/desktop or search for Power BI Desktop in the Microsoft Store
2. Download and install Power BI Desktop
3. Open Power BI Desktop and sign in with your Microsoft work account if prompted

Step 7 : Connect to NetSuite via Get Data → ODBC

This is the same System DSN setup as querying NetSuite from any other tool the only difference from here is that Power BI reads the DSN directly instead of going through a database.

1. On the Home tab, click Get Data
2. Choose ODBC from the list (under Other, or search "ODBC" in the box)
3. Click Connect
4. In the Data source name (DSN) dropdown, select the System DSN you created in Step 4 for example NetSuite
5. Leave the SQL statement box empty for now and click OK

Power BI will prompt for credentials the first time you connect through this DSN.

1. Choose Default or Custom as the credential type
2. Enter your NetSuite username and password
3. Select the appropriate level to apply these credentials to (this connection, or all connections to this data source)
4. Click Connect

These are NetSuite credentials not Windows or Microsoft credentials

Enter the username and password you use to log into NetSuite. Do not enter your Windows login or Microsoft work account password here.

Step 8 : Select NetSuite Tables and Load the Data 

Once connected, the Navigator window opens and lists every NetSuite table exposed through SuiteAnalytics Connect.

1. Browse or search the table list for example customer, transaction, or item
2. Tick the checkbox next to each table you want to bring into Power BI
3. Click a table name to preview its columns and sample rows on the right
4. Click Transform Data to open Power Query and shape the data before loading, or click Load to bring it in as-is

Troubleshooting Common Problems

• Cannot create System DSN NetSuite driver not in the list : The ODBC driver was not installed correctly or you are opening the wrong ODBC administrator. Make sure you downloaded and installed the 64-bit driver and are opening ODBC Data Sources (64-bit), not the 32-bit version. Search specifically for "ODBC Data Sources (64-bit)" in Windows search.
• NetSuite DSN does not appear in the Power BI ODBC dropdown : Power BI Desktop only lists DSNs that match its own bitness. If you installed the 64-bit ODBC driver and created a 64-bit System DSN, make sure you are running the 64-bit version of Power BI Desktop (the default download). Also confirm the DSN was created under the System DSN tab, not User DSN.
• Power BI shows "Unable to connect" after selecting the DSN : This usually means the credentials entered in Power BI's connection prompt are wrong, or a previous set of cached credentials is being reused. In Power BI Desktop, go to File → Options and settings → Data source settings, find the NetSuite DSN, click Edit Permissions, and clear the stored credentials. Reconnect and re-enter your NetSuite username and password.

: