Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Power BI Fabric Audit Logs

Hello everyone! I’m working on tracking Power BI report activity and trying to simulate the ExecutionLog3 functionality from Report Server in Fabric. To achieve this, I’m using the Power BI REST API...
  • v-karpurapud's avatar
    1 year ago

    Hello Anonymous 

    Thank you for reaching out regarding Power BI Fabric Audit Logs. We understand your need to track detailed report activity.

     

    Unfortunately, the Power BI REST API’s Admin - Get Activity Events endpoint does not directly provide the start and end times of report execution and status codes like rsInternalError or rsSuccess.

     

    As a workaround, you can approximate start times using the ActivityDateTime field and track status through custom logging and inferred actions.

     

    To implement custom logging within your Power BI reports to capture detailed execution metrics, including start and end times and execution status, you can follow these steps:

     

    Using Azure Log Analytics

     

     1. Set Up Azure Log Analytics:

    • Create a Workspace: In the Azure portal, create a Log Analytics workspace.
    • Connect Power BI: In the Power BI admin portal, configure your Premium workspace to send logs to the Log Analytics workspace.

      2. Configure Diagnostic Settings:

    • Enable Logs: In the Power BI admin portal, enable diagnostic logging for your workspace.
    • Select Log Categories: Choose categories like AuditLogs, UsageMetrics, and PerformanceMetrics.

       3. Query Logs:

    • Use KQL: In the Log Analytics workspace, use Kusto Query Language (KQL) to query and analyze logs. Extract start and end times, execution status, and other metrics.

     

    If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

     

    Thank you!