Hello,
I'm trying to Automate reporting with Netsuite Data to PowerBi.
Not sure what the best way is to do this and maybe somebody could point me in the correct direction.
We have Multiple Saved Searches from Netsuite that we save as CSV and what to automate this with workato to update automatic to PowerBI.
As we are working with large datat sets i was thinking with below options:
1: setup a SQL server to get large data sets
2: Use Workato File Storage to keep adding new data so we don't have to run the full saved searches everytime (problem is we don't have the Workato files storage in our package)
3: Data Tables within the recipe ( also not in our Package)
Could somebody point we in the right direction or maybe an example recipe working with large data set extraction from netsuite?
3:
