I need to get journal entries data via Power BI.
What is the best practice to connect? API? ODBC?
Yes! There is a way simpler way than ODBC. Check out www.tacticalconnect.com for a saved search based connector that lives in NetSuite.