Forum Discussion
Solved
Log Daily Results into New Table
I have a report in the Power BI desktop that shows the total value of our inventory. The report refreshes nightly and the data comes from an SQL table. This data is always a snapshot- there is n...
Power BI is a reporting data base, not a data storage tool. You should store the historical data in SQL Server and load it from there
MattAllington
Community Champion
Community ChampionPower BI is a reporting data base, not a data storage tool. You should store the historical data in SQL Server and load it from there
hank you Matt!