Forum Discussion

rsbin's avatar
rsbin
Community Champion
3 years ago

Connecting with NetSuite

Good Day, Would like to connect with anyone who has had experience connecting with NetSuite as a datasource. Have spent some time reviewing the older threads in here, but could not find anything ...
Need Help
Jerr31's avatar
Jerr31
Regular Visitor
2 years ago

Hi,

 

Currently we synch our NetSuite tables via an ODBC driver icm with PowerBi Gateway to our managed SQL. We are planning to migrate from NetSuite.com to NetSuite2.com via DWI role 57. Do you have experience with delta updates direct though the REST API?

 

andyclap's avatar
andyclap
Advocate IV
1 year ago

Not sure how I missed this one ...

I presume you mean pushing info into the semantic model via the REST POST to rows? While it's feasible, I decided against it as I don't fell the semantic model has quite the right operational characteristics to become the source of the report data. Until fabric lakehouse gets native netsuite or installable odbc connectors, I use my own data lake and refresh the entire semantic model from that. Thankfully we don't have enough data to mandate incremental refresh; but even if we did, I'd still prefer to do that in another platform, upstream of exposing it as a semantic model.