Forum Discussion
Log Weekly Results into New Table
Hi, Anonymous
If the total compliance percentage is calculated using the measure in Power BI, I don’t think the value of the historical compliance percentage can be inserted into a new table every week. Because the data is updating and the measure can only calculate based on the current data. The historical data can not be recorded in Power BI.
Maybe you can find the solution using procedures in SqlServer.
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
I have the same issue/need as the thread starter.
I have an activity tracker with a column "Activities" and a column with "Status".
The report refreshes daily and the data comes from an Excel file stored in a sharepoint folder.
I would like to log the results from the tracker each week into a new table and then use that table to show a change in historical completion every week. I don't use any measures to the data. Is it possible to set up a process in Power BI where it automatically stores the data in a log table each week on Monday 6 am for example? If not, would it be possible to store the log data somewhere else using some other tool?
Thanks!
Power BI has no memory. You need to do that in the upstream system. You already have a sharepoint folder. Use that for storage, and then use Power BI to combine the daily files (via the Sharepoint Folder connector)
