top of page

Introducing the Power BI Activity Log



We are excited to announce the availability of a new Power BI API called the activity log, which enables Power BI service admins to track user and admin activities within a Power BI tenant. It is comparable to the unified Office 365 audit log in the sense that both logs contain a complete copy of the Power BI auditing data, but there are also several key differences that are particularly important for Power BI service admins, as the following table reveals.





To distinguish the Power BI-specific log from the unified audit log, Power BI chose the name activity log, but the Power BI auditing data within both logs is identical. In this way, global admins and auditors can continue to use the Security and Compliance Centers for all their auditing needs, while Power BI service admins now have a straightforward way to access and download the data they need to monitor the actions of their users and administrators in their Power BI tenant. You could call the activity log an audit log as well, but different names help to avoid confusion.


So, what can you do with the Power BI activity log? For starters, you can write an administrative application based on the Power BI REST APIs to export the activity events into a blob store or SQL database so that you can build a custom usage report on top of the exported data. In the ActivityEvents REST API call, you must specify a start date and end date and optionally a filter to select activities by activity type or user id.


Because the activity log may possibly contain a large amount of data, the ActivityEvents API currently only supports downloading up to one day of data per request. In other words, the start date and end date must specify the same day, as in the following example. Make sure you specify the DateTime values in ISO 8601 compliant UTC formats.

https://api.powerbi.com/v1.0/myorg/admin/activityevents?startDateTime='2019-08-31T00:00:00'&endDateTime='2019-08-31T23:59:59'

If the number of entries is large, the ActivityEvents API returns only around 5,000 to 10,000 entries and a continuation token. You must then call the ActivityEvents API again with the continuation token to obtain the next batch of entries, and so forth, until you have retrieved all entries and no longer receive a continuation token. The following example shows how to use the continuation token.

https://api.powerbi.com/v1.0/myorg/admin/activityevents?continuationToken=’%2BRID%3ARthsAIwfWGcVAAAAAAAAAA%3D%3D%23RT%3A4%23TRC%3A20%23FPC%3AARUAAAAAAAAAFwAAAAAAAAA%3D’

As a general rule, regardless of the number of entries returned, if the results include a continuation token, make sure you call the API again with that token to retrieve the remaining data, until a continuation token is no longer returned. It can happen that a call even returns a continuation token without any event entries. But don’t let the absence of activity events distract you. Just keep calling back with that continuation token. Here is how you can code against the continuation token that is returned in the response:

while(response.ContinuationToken != null)
{
    // Store the activity event results in a list for example
    completeListOfActivityEvents.AddRange(response.ActivityEventEntities);

    // Make another call to the API with continuation token
    response = GetPowerBIActivityEvents(response.ContinuationToken)
}
completeListOfActivityEvents.AddRange(response.ActivityEventEntities);

It might be easier to download activity events by using the Power BI Management cmdlets for PowerShell, which include a Get-PowerBIActivityEvent cmdlet that handles the continuation token for you automatically. The Get-PowerBIActivityEvent cmdlet takes a StartDateTime and an EndDateTime parameter with the same restrictions as the ActivityEvents REST API, meaning the start date and end date must reference the same date value because you can only retrieve the activity data for one day at a time.


The following screenshot illustrates how to download all Power BI activities in a sample tenant for December 1st. As the results indicate, the script downloaded almost 19,000 entries, which the command then converted from JSON into .NET objects for straightforward access to individual activity properties. The script could now  process each object individually in a foreach loop.



As mentioned, you can filter the activity events by activity type and user id. The following screenshot demonstrates how to download only the events data for the ViewDashboard activity. For additional information about supported parameters, use the command Get-Help Get-PowerBIActivityEvents.



And that’s it for a quick introduction of the Power BI activity log. If you are a Power BI service admin, we hope this feature gives you more visibility across your Power BI tenant and more flexibility to build admin solutions that help increase your productivity. Future improvements might include a user interface for searching the activity log in the Power BI Admin Portal with the capability to download the results into a .csv file as well as additional filtering capabilities in the ActivityEvents REST API and Get-PowerBIActivityEvent cmdlet. So, stay tuned for even more capabilities empowering Power BI service administrators.




Some opinions expressed in this article may be those of a guest author and not necessarily Analytikus. Staff authors are listed in https://powerbi.microsoft.com/es-es/blog/the-power-bi-activity-log-makes-it-easy-to-download-activity-data-for-custom-usage-reporting/


1,249 views6 comments

6 Comments


Asta
Asta
Jun 05

This premium capacity metrics app seems like a game-changer for verizon fios billing problems businesses relying on Power BI. Its comprehensive features promise to streamline analytics processes, enhance performance tracking, and optimize resource allocation. With customizable dashboards and real-time insights, it empowers users to make data-driven decisions swiftly and confidently. The app's user-friendly interface makes it accessible to both novice and seasoned analysts alike. Overall, it appears to be a valuable tool for maximizing the potential of Power BI, ensuring efficiency and effectiveness in data analytics workflows.

Like

Artificial Intelligence (AI) is increasingly being integrated into educational settings to provide personalized and adaptive learning experiences for students. This integration primarily focuses on enhancing student engagement, understanding, and academic performance through various AI-driven tools and methodologies.

Like

The childcare industry is the top growing sector to work in. Early childcare is crucial for the overall development and growth of children. With the intent of providing the best care and safe environment for children for their growth, the individual or caregiver is provided the necessary training. Many education institutions offer short-term and long-term degree, diploma, and certificate programs in childcare. Option for the course you may work on several projects to obtain a theoretical and practical understanding of the subject. Feeling exhausted with the research and analysis process, you can get Early childhood assignment help from professional experts. Many writing services in the USA offer the best assistance to students for their writing needs. The experts are well-versed in…

Like

You've come to the right place if you're looking for online assignment help. This tutorial will teach you everything you need to know about selecting and using the best assignment service in Ireland. When looking for a service, make sure they are reputable and qualified. You should read reviews from previous customers to get a sense of the service's quality. Make sure the service has a team of qualified professionals who can help you with your needs. Most services offer a money-back guarantee, ensuring that you get exactly what you pay for. If you are unsure whether assignment help is right for you, you can try it out for free in Ireland. This allows you to test the service and…

Like

This is an interesting topic to study as it affects various aspects of our lives, including physical and mental health, work efficiency and productivity, and social interactions. Using the service https://payforessay.net/ makes it possible to help students write essays. By turning to this service, students can count on quality assistance that will help them succeed in their studies and study their chosen topic more deeply and comprehensively.

Like

POST

bottom of page