Forum Discussion
Helper INetsuite connectivity with Power BI
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
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:
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
4 Replies
v-qiuyu-msftCommunity Support
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:
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- karaoan
Kudo Kingpin
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)
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.
- Aryna
Post Partisan
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:
- My own script that automatically extracts data from NetSuite API
- My own Power BI dashboard that has some formulas for analysing this data.
