Forum Discussion
Importing NetSuite Inventory Table from specific date
Hello,
I am trying to import our inventory table from NetSuite from a specific date instead of "today". I can pull in the inventory table, but it always refreshes the data from today. I want to also import this same table, but from Today minus 30 days.
The specific report from NetSuite defaults you to today's day or you can choose whichever day at the bottom (As Of). Which makes sense, but I am running an analysis where I want the inventory level from 30 days ago. 30 days from current day.
2 Replies
Hi kellen1918 ,
In power bi, NetSuite does not have a direct connection method, you can try to use ODBC
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-using-generic-interfaces
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Kellen,
Are you able to actually get data from NetSuite Reports into Power BI (using the web query capability), meaning your question is just on how to apply the specific filters you want?
