Importing NetSuite Inventory Table from specific date

[kellen1918]

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.

[paul_sanders]

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?

[Anonymous]

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

https://community.powerbi.com/t5/Community-Blog/How-to-Connect-to-an-ODBC-Data-Source-From-Power-BI/...

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.