Power Bi Daily Inventory Levels

Need help trying to figure out how to get inventory levels by day in Power BI with direct query connection(cannot use calculated tables as it does not refresh once published to the service).   the ...