Forum Discussion

afaque03's avatar
afaque03
Icon for Helper I rankHelper I
9 years ago
Solved

Netsuite 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 st...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

     

Aryna's avatar
Aryna
Icon for Post Partisan rankPost Partisan
2 years ago

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.