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
Tag: SQL
Date conversions/considerations using SQL formula
Date conversions/considerations using SQL formula
Using TRIM, LTRIM, and RTRIM for Formula functions
This article gives examples on using some common string functions that can be used for NetSuite search formulas via user interface or script, and on custom formula fields. TRIM: Removes leading or trailing characters (or both) from a character string Syntax: TRIM([ { { LEADING | TRAILING | BOTH } [ trim_character ]| trim_character}FROM ]trim_source)… Continue reading Using TRIM, LTRIM, and RTRIM for Formula functions