Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
rsbin
Super User
Super User

Connecting with NetSuite

Good Day,

Would like to connect with anyone who has had experience connecting with NetSuite as a datasource.

Have spent some time reviewing the older threads in here, but could not find anything that provides any real-life experiences.

If you have, would appreciate if you would reach out.

 

Kindest Regards,

3 REPLIES 3
andyclap
Helper II
Helper II

I've done quite a bit of netsuite integration with PowerBI - although it's an old question, here's a quick brain-dump:

 

We were based around netsuite ODBC with an on-prem data gateway; however this was extremely slow - there seem to be rate limits, and there are some very low level driver problems with power BI being able to optmize the ODBC queries that aren't going to be fixed any time soon. The thirdparty ODBC drivers are a bit better for this (CData). However you're still shifting a lot of data around as PowerBI data partitioning isn't really compatible with netsuite, as records can be updated.

 

Rather than change to using the REST API (which would require a fair amount of custom work as there is specific paging and the schema is subtly different), we decided to use a simple thirdparty data integration system (Stitch) that supported NetSuite to incrementally replicate most of the data into a data-lake style database, and build the semantic model from there. For some of the less straightforward tables (e.g. where there's a filter needed to cut down volume), we use logic apps to schedule java azure functions (as they can use the jdbc driver for both NetSuite and the staging database). Deletions and transaction-line amendments are handled from the deletion table via a periodic clean-up process on the database.

 

It would be great to do something like this in Fabric pipelines into a data-lake, and while I hold out hope for a 3rd party connector marketplace to mature, Netsuite ODBC drivers aren't supported right now among other limitations. So we'd be back to managing a gateway and bespoke incremental refresh code.

 

One other tip is the NS tables are extremely wide, so make sure your semantic model build starts small just to cover your reporting and keep things from getting out of hand.

v-yiruan-msft
Community Support
Community Support

Hi @rsbin ,

Base on my research, there is no direct connector to connect NetSuite in Power BI Desktop. You can try to use a third-party connector such as CData or ZappySys. These connectors allow you to access NetSuite data through the ODBC or REST API protocols. You can find more information and instructions on how to use these connectors on their respective websites:

Alternatively, you can export NetSuite data to a CSV file and then import it to Power BI using the Text/CSV connector. However, this method does not support live or incremental refresh of the data.

  • Log in to your NetSuite account and navigate to the Reports tab.
  • Select the report that you want to export and click on the Customize button.
  • On the Customize Report page, click on the Export button and choose CSV as the format.
  • Save the CSV file to your local machine or cloud storage.

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

To connect with NetSuite as a data source:

  1. Review NetSuite's SuiteTalk web services documentation for integration options.
  2. Join online NetSuite user communities to learn from others' experiences.
  3. Consider consulting experts or developers specializing in NetSuite integrations.
  4. Explore integration platforms offering pre-built connectors for easier integration.

For more information read our blog on netsuite integrations  

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors