cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
achase Regular Visitor
Regular Visitor

Usage Metrics - Store Older Data upon refresh

Hello, 

 

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.

 

Let me know if you know of a workaround

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Usage Metrics - Store Older Data upon refresh

Hi there

If you are looking for more long term data, you would have to get it via the Office 365 Audit Logs.

The Audit logs also have a lot more information that could assist with building the usage over time.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog
1 REPLY 1
Super User
Super User

Re: Usage Metrics - Store Older Data upon refresh

Hi there

If you are looking for more long term data, you would have to get it via the Office 365 Audit Logs.

The Audit logs also have a lot more information that could assist with building the usage over time.

Did I answer your question? Mark my post as a solution!

"Proud to be a Datanaut!"


Power BI Blog

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 110 members 1,534 guests
Please welcome our newest community members: