Netsuite connectivity with Power BI

[afaque03]

Hello Friends,

I  Need Help in connecting Power BI to netsuit services and start creating reports and dashboards using the netsuit data.

If any one has done the connection please do share the steps

[Aryna]

Hi, I developed multiple Power BI form Netsuite before. Here is an example: https://vidi-corp.com/cases/netsuite-sales-organisation-analysis/

The resources that I used  are:

1. My own script that automatically extracts data from NetSuite API
2. My own Power BI dashboard that has some formulas for analysing this data.

[Anonymous]

You can connect NetSuite and Power Bi via Skyvia — the no-coding integration solution. This integration isn't performed directly — Skyvia provides it through a database or cloud data warehouse with automatic schema creation. Then you can connect Power BI to this database or data warehouse easily.

[karaoan]

Another option to connect from Power BI to Netsuite is Acterys: Planning, Consolidation For Power BI & Excel it creates an Azure SQL data warehouse optimized for analysis with the required Netsuite tables. Acterys also adds comprehensive planning capabilities with 8 Power BI custom visuals: Acterys Planning & Analytics For Power BI & Excel (microsoft.com)

[v-qiuyu-msft · Accepted solution]

Hi @afaque03,

Based on my research, there are three options to get data from the Netsuite service:

1. Purchase the SuiteAnalytics Connect (ODBC) functionality from NetSuite

2. Leverage NetSuite’s Web Query report functionality

3. Leverage API Server

For more information, see:

Connect NetSuite to Power BI

Use the API Server in Microsoft Power BI

Currently, there is no OOTB connector for Netsuite, you can vote on this idea item: NetSuite.

Best Regards,
Qiuyun Yu