Power BI REST API - Get Activity Events

[likhitha_p]

Hi ,

I am working with Power BI Get Activity Events REST API. I understand that CreationTime column is about when the activity is created/started.

I am looking for data to understand how long that activity was being performed.

For example, View Report activity is created at 2023-01-25 10:05:45, but not able to find data when this activity ended.

Is there any information we can get to understand the end time of the activity which helps to find out the actual time spent on that activity? 

[Sahir_Maharaj]

If you have any other questions or if there is anything else I can assist with, please let me know.

[Sahir_Maharaj]

This could be done by adding custom code to your report that logs the start and end times of specific events, such as a user viewing a report or interacting with a dashboard.

You could then use the Get Activity Events REST API to retrieve the log data and use it to calculate the duration of specific activities.

This method would give you more control and accuracy over the data, but requires more development effort.

[Sahir_Maharaj]

However, this method is not always accurate and the actual time spent on the View Report activity could be longer or shorter than the time between the two activities.

Another option is to use custom tracking and logging in your Power BI report to log the start and end times of specific activities.

[likhitha_p]

Hi @Sahir_Maharaj ,

Thank you for your response. 

Can you please help me by providing some more information on how to use custom tracking and logging in Power BI report to log the start and end times of specific activities ? 

That would be really helpful!

[Sahir_Maharaj]

As a workaround, you could use the next activity in the timeline to estimate the end time of the previous activity. For example, if you have a View Report activity followed by a Export to PDF activity, you could assume that the View Report activity ended when the Export to PDF activity started.

[Sahir_Maharaj]

Hello @likhitha_p,

Unfortunately, the Power BI Get Activity Events REST API does not provide information on when a specific activity ended. The CreationTime column only provides information on when the activity was created or started, but not on when it ended.