A daily email is sent to the warehouse managers each day that includes the inventory value as of that day. I’ve been adding these numbers to a spreadsheet so we can do some other calculations, but I’d like to find a way for Power BI to add this data to the history table. Right now the history table is an Excel spreadsheet and it might be best to write to the Excel file so future updates to the report don’t overwrite the historical data.
Attached is a pbix file with sample data and an overview of my objectives. Also attached is the underlying Excel file. Thanks for any help the community can provide.
Hi @npeterson - For making it dynamic, you can use Power Automate. This will allow data to be extracted from Power BI and loaded into static Excel file dynamically. There are examples available online on how to setup the flow.