Netsuite to Power BI live feed

[Nathan_M_]

Hey all,

Fairly new to Power BI and Power Query and have completed some dashboards for clients using netsuite. Currently I am downloading data from netsuite into excel cleaning the data in Power Query and then importing it into Power BI which means i am manualy updating the dashboard every 1-2 days. 

What would be the best and easiest way to connect netsuite to the dashboard to have a live automatic feed?

Any help would be appreciated!

[Shravan133 · Accepted solution]

Use NetSuite’s ODBC/JDBC Driver

NetSuite provides an ODBC (Open Database Connectivity) or JDBC (Java Database Connectivity) driver that allows you to connect directly to NetSuite's data.

1. Set Up ODBC/JDBC Connection:

   • Download and Install: Obtain the ODBC or JDBC driver from NetSuite’s support or your NetSuite account manager.
   • Configure the Driver: Set up the ODBC/JDBC driver with your NetSuite credentials and endpoint.

2. Connect Power BI to NetSuite:

   • Open Power BI Desktop: Go to Home > Get Data.
   • Select ODBC or JDBC: Choose the ODBC/JDBC option based on the driver you installed.
   • Enter Connection Details: Provide the connection string and credentials.
   • Load Data: Import the data into Power BI for reporting and visualization.

2. Use NetSuite’s RESTlets or SuiteTalk API

NetSuite offers RESTlets and SuiteTalk (SOAP-based API) that can be used for integration.

1. Develop a RESTlet or SuiteTalk Integration:

   • RESTlets: Create custom RESTlets in NetSuite that expose the data you need. RESTlets allow you to create custom web services for accessing NetSuite data.
   • SuiteTalk API: Use the SuiteTalk API to access NetSuite data programmatically.

2. Connect Power BI Using Web Connector:

   • Open Power BI Desktop: Go to Home > Get Data > Web.
   • Enter API Endpoint: Input the URL for your RESTlet or SuiteTalk API endpoint.
   • Authenticate: Provide the necessary authentication (e.g., OAuth tokens, API keys).
   • Load Data: Fetch and transform data using Power Query.

3. Use a Third-Party Integration Tool

There are third-party tools and connectors available that specialize in connecting NetSuite with Power BI.

1. Find a Connector:

   • CData: Provides ODBC/JDBC drivers and connectors specifically for NetSuite.
   • Zyte: Offers data integration solutions that include NetSuite.
   • Power BI Data Connectors: Search for NetSuite-specific connectors in the Power BI marketplace or AppSource.

2. Set Up the Connector:

   • Install and Configure: Follow the instructions provided by the connector tool to set up the connection.
   • Connect Power BI: Use the connector to directly import data into Power BI.

[Nathan_M_]

What is the price range for each of these options?