The requirement was to connect NetSuite searches with Power BI in order to create the reports. We can load tables from NetSuite to Power BI based on the permissions given in the custom role. The searches cannot be load this way. As solution to this we can use SQL queries to recreate the same search… Continue reading SuiteQL to generate a Customer saved search in Power BI via ODBC connector
Tag: Power BI
SuiteQL to generate a saved search in Power BI via ODBC connector
The requirement was to connect NetSuite searches with Power BI in order to create the reports. We can load tables from NetSuite to Power BI based on the permissions given in the custom role. The searches cannot be load this way. As solution to this we can use SQL queries to recreate the same search… Continue reading SuiteQL to generate a saved search in Power BI via ODBC connector
NetSuite ODBC-Power BI Basic connection Manual and solution to Report Refreshment.
Basic connection setup of ODBC driver with NetSuite account and then connect NetSuite with Power BI
The requirement was to Connect NetSuite account with Microsoft Power BI, to create reports in Power BI using NetSuite data. For that Suite Analytics Connect Service must be enabled in the NetSuite account. The detailed procedure on this will be described in the document below.