The table is a temporary table so won't hold data in it for Power Bi to extract.
1st question is how time sensitive is your reporting requirement? Power Bi is not live data so if you want a live operational report, you will need to refresh the data manually in Power Bi Desktop. If this is a report you want to dashboard, it won't be up to date. If you want to put it at an end users finger tips with live data, something like Jet may be better.
With regard to building the data set required, you need to calculate the available inventory by item, by location, by date. To do this, you need to gather your inventory data for the BOM components for the location and then all supply and demand up to and including the required date + any reservations that will restrict availability of physical/planned stock. All data must be location specific.
It's perfectly achievable but it's a lot of data to crunch. You need to consider all your supply and demand when calculating the item availability. e.g.
Inventory
Sales order demand
Assembly / Production Component demand
Job Demand
Outbound Transfers
Purchase Return Orders
Purchases
Assembly / Production Output
Inbound Transfers
Sales Return Orders
Reservations
