RE: Get journal entries data from Netsuite to Power BI
I need to get journal entries data via Power BI.
What is the best practice to connect? API? ODBC?
Rookie Asked on October 8, 2020 in Best Practices.
But how can I set up ODBC?
I couldn’t find any documentation that doesn’t include 3-d party tools.
on October 9, 2020.
You need to have SuiteAnalytics Connect available in your account (it has an additional cost). You can verify it on Setup > Company > Enable Features > Analytics tab. If it’s not listed there, you company has not provisioned the service.
If it is present, then enable it, then check the docs at https://docs.oracle.com/cloud/latest/netsuitecs_gs/NSALC/NSALC.pdf