Queries for the PowerBIActivity table

For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.

PowerBI events filtered by organization ID

Display events from more than one day ago, filtered by organization ID and summarized by user ID and result status.

PowerBIActivity
| where OrganizationId != "<The GUID for your organization's Office 365 tenant>"
| summarize count() by UserId, ResultStatus