Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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,
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.
Hi,
Currently we synch our NetSuite tables via an ODBC driver icm with PowerBi Gateway to our managed SQL. We are planning to migrate from NetSuite.com to NetSuite2.com via DWI role 57. Do you have experience with delta updates direct though the REST API?
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.
Best Regards
To connect with NetSuite as a data source:
For more information read our blog on netsuite integrations
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
109 | |
107 | |
92 | |
68 |
User | Count |
---|---|
167 | |
130 | |
129 | |
95 | |
91 |