topic Re: Power BI REST API - Get Activity Events in Developer

Power BI REST API - Get Activity Events

likhitha_p — Thu, 09 Feb 2023 15:03:29 GMT

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?

Re: Power BI REST API - Get Activity Events

Sahir_Maharaj — Thu, 09 Feb 2023 19:56:52 GMT

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.

Re: Power BI REST API - Get Activity Events

Sahir_Maharaj — Thu, 09 Feb 2023 19:57:11 GMT

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.

Re: Power BI REST API - Get Activity Events

Sahir_Maharaj — Thu, 09 Feb 2023 19:57:29 GMT

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.

Re: Power BI REST API - Get Activity Events

Sahir_Maharaj — Thu, 09 Feb 2023 19:57:45 GMT

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.

Re: Power BI REST API - Get Activity Events

Sahir_Maharaj — Thu, 09 Feb 2023 19:58:19 GMT

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

Re: Power BI REST API - Get Activity Events

likhitha_p — Thu, 09 Feb 2023 21:32:04 GMT

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!