Forum Discussion
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 ...
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:
- CData: https://www.cdata.com/kb/tech/netsuite-odbc-powerbi.rst
- ZappySys: https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
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
To connect with NetSuite as a data source:
- Review NetSuite's SuiteTalk web services documentation for integration options.
- Join online NetSuite user communities to learn from others' experiences.
- Consider consulting experts or developers specializing in NetSuite integrations.
- Explore integration platforms offering pre-built connectors for easier integration.
For more information read our blog on netsuite integrations