Analyze in excel how many people

[Anonymous]

Hello.

Can you help me, I need to determine how many people in the company use Analyze in excel in reports, is such information stored somewhere in the metrics? Is there any way to get it?

[ibarrau · Accepted solution]

Hi. Yes you can. But it's not an easy one. You can use the Power Bi Rest API to request activity logs.

https://docs.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events

Those logs are the following:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing#operations-available-in-the-a...

You can find the logs of analyze in excel in there.

The best solution would be taking that data on a regular basis because it only keeps 90 days of data. So if you want historic data, you need to persist it. But if 90 days is ok, then you can run it one time each time you want to see that.

I hope that helps,

P/D There are libraries to help you with this in different laguanges, like SimplePBI with python for example https://pypi.org/project/SimplePBI/