I have a Power BI report that is refreshed with new data each day, historical data isn't saved in the server so I can't look at yesterday, for example, to see what the total was. Is there any way to create a new table in Power BI that can save this data each time it is updated for say the last 15 days? I want to use the table to create a very simple line chart so that we can compare today's total with the daily totals for the last two weeks. I can create the chart easily enough but can't figure out a way to save the totals each day automatically. I realize this may be a bit outside of what Power BI does but if anyone has a suggestion I would be very greatful, thanks.
I have tried to use a Scorecard, which does exactly what I want, but I am not able to share these on the SharePoint site so others can view. It looks like that funcionality may be on the way but right now isn't available.
