I am analysing the data in my company for operational purposes which uses NetSuite, besides the other tools’ exports, I export 3 searches and 1 report from NetSuite on daily basis to connect them with the other data sources and prepare the insights for our stakeholders.

The mentioned NetSuite exports are for all the transactions data on the company level, so, they are CSV files with thousands of rows. Exporting such big files takes good time from my work day, hence, I was chasing an automation solution enabling me to connect the Power Bi to the NetSuite data sources.

I found out about the possibility of subscribing to these 3 searches and 1 report so I receive them in my mailbox on daily basis, this was an optimal solution as Power Bi could be connected to my mailbox and get the sent subscription from there every day, however, I discovered that I receive CSVs with fixed limit of 10,000 rows only, well, one of the searches here is generated in +141,000 rows CSV (for the billable items).