Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hey all,
Fairly new to Power BI and Power Query and have completed some dashboards for clients using netsuite. Currently I am downloading data from netsuite into excel cleaning the data in Power Query and then importing it into Power BI which means i am manualy updating the dashboard every 1-2 days.
What would be the best and easiest way to connect netsuite to the dashboard to have a live automatic feed?
Any help would be appreciated!
Solved! Go to Solution.
NetSuite provides an ODBC (Open Database Connectivity) or JDBC (Java Database Connectivity) driver that allows you to connect directly to NetSuite's data.
Set Up ODBC/JDBC Connection:
Connect Power BI to NetSuite:
NetSuite offers RESTlets and SuiteTalk (SOAP-based API) that can be used for integration.
Develop a RESTlet or SuiteTalk Integration:
Connect Power BI Using Web Connector:
There are third-party tools and connectors available that specialize in connecting NetSuite with Power BI.
Find a Connector:
Set Up the Connector:
NetSuite provides an ODBC (Open Database Connectivity) or JDBC (Java Database Connectivity) driver that allows you to connect directly to NetSuite's data.
Set Up ODBC/JDBC Connection:
Connect Power BI to NetSuite:
NetSuite offers RESTlets and SuiteTalk (SOAP-based API) that can be used for integration.
Develop a RESTlet or SuiteTalk Integration:
Connect Power BI Using Web Connector:
There are third-party tools and connectors available that specialize in connecting NetSuite with Power BI.
Find a Connector:
Set Up the Connector:
What is the price range for each of these options?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.