Record/Retain Calculated Values on Routine Basis

[Anonymous]

I have a bit of a unique situation I need assistance with.

I have a SaaS service for document control that produces alot of reports in CSV format but these reports are always "current state" and do not keep historical values. At the current time, I take weekly exports of the reports I need and upload the CSV to SharePoint. I use PowerBI to collect these documents and visually present the data.

Some of the values are calculated/counted in some form or fashion. For example, it calculates how many documents are expired. Again, this only reflects current state since it does not keep a historical list.

Is it possible to record the calculated values PowerBI processes and record those into a SharePoint list or manual PowerBI table on a recurring basis? IE, it records the value of expired documents daily so I can have a historical graph of how many documents were expired over a given time period.

I thought about Power Automate but not sure if this would help since the values are calculated from PowerBI. Its also difficult to use CSV files in powerautomate.

[Greg_Deckler]

@Anonymous I feel like you could do this with Power Automate if you tied the workflow to a dataset refresh to immediately go out and update a SQL database with values pulled from the REST API for example or similar: Solved: Extract Power BI content using Power Automate / Fl... - Power Platform Community (microsoft.com)

Also, Scorecards and Goals are a really nice way to solve this problem if you have Premium or PPU.