I've worked in an environment that used a data warehouse. export out data from NetSuite a couple of times a day into an Azure SQL Server. Then connect PowerBI. It was totally custom though.