I am looking to monitor Power BI Usage by employees across our business to see how employees are using the system. What I have done is used the usage metrics "Analyze in excel" feature. This gives me a pivot table which i can then manipulate to show the data I want. However, When I refresh the data, it overwrites the existing data across the board. because usage metrics only shows the last 90 days of usage, this means that i can only see data from 90 days ago.
I essentially want to append the data in excel so that it stores the previous days/weeks/months (whatever would work) data and then when the data is refreshed, the updated data is then pasted below the old data. (I dont really care if there are duplicates cause I can just write a query to delete the duplicates in power BI) This way I would have access to data from longer than 90 days ago when I build a Power BI Report.