Using Azure Log Analytics in Power BI (Preview)
Power BI is integrating with Azure Log Analytics (LA) to enable administrators and Premium workspace owners to configure a Log Analytics connection to their Power BI subscription. This article describes how the integration between Log Analytics and Power BI works, and provides examples of how you can use Azure Log Analytics in your Power BI Premium subscription.
Azure Log Analytics (LA) is a service within Azure Monitor which Power BI uses to save activity logs. The Azure Monitor suite lets you collect, analyze, and act on telemetry data from your Azure and on-premises environments. It offers long-term storage, an ad-hoc query interface and API access to allow data export and integration with other systems.
The Power BI integration with Log Analytics exposes events from the Analysis Services engine. The events are derived from existing diagnostic logs available for Azure Analysis Services.
Once connected to Power BI, data is sent continuously and is available in Log Analytics in approximately 5 minutes. The following diagram shows how Azure Monitor operates, with the path taken by Power BI highlighted.
The following sections describe the integration of Azure Log Analytics with Power BI, the requirements necessary to connect Azure Log Analytics to Power BI, and considerations to keep in mind.
Available scopes for logging
An Azure Log Analytics connection is currently supported for Premium workspaces in Power BI. The following table provides more information about the Workspace-level Log Analytics configuration.
|Configuration level||Role / permission||Destination Table in Log Analytics||Details|
|Workspace||Power BI workspace owner, or Log Analytics workspace owner||PowerBIDatasetsWorkspace||- Must be allowed by the tenant administrator
- Logs activity from the workspace only
- Premium workspaces only
- Workspace v2 only
The following section provides examples of how you might put logging to use in Power BI.
Examples of logging scenarios
This section provides some examples of how you might configure Log Analytics for Power BI, and how selections you make will impact what is logged, and how the information is provided.
Example 1: Workspace logs for one workspace only
In this example, only workspace logs from Workspace A are sent to a dedicated Log Analytics workspace:
Example 2: Workspace logs sent to dedicated Log Analytics workspaces
In this example, workspace logs from two differentPower BI workspaces are each sent to separate, dedicated Log Analytics workspaces:
These examples highlight the various ways you can use Azure Log Analytics with Power BI, and get the log information you need.
In another article, you can see how to configure Azure Log Analytics to work with Power BI, with specific steps and requirements to get your logging working properly.
Considerations and limitations
Keep the following considerations and limitations in mind when working with Azure Log Analytics and Power BI:
- Sovereign clouds are not currently supported.
- Only Premium workspaces are supported.
- Only Workspace v2 support Log Analytics connections.
- Activities are only captured for datasets physically hosted within the Premium workspace where you configure logging. For example, if you configure logging for Premium workspace A, you will not see logs for any reports within that use datasets hosted in Azure Analysis Services. You will also not see any logs for shared datasets that are not in Premium workspace A. To capture activities for shared datasets, configure logging on the workspace that contains the shared dataset, not the workspace that contains the report.
- You cannot connect multiple Power BI workspaces to the same Log Analytics workspace yet. This restriction will be removed during the Preview.
- Datasets created on the web by uploading a CSV file do not generate logs.
- If you have Multi-Factor Auth (MFA) in place for Azure but not Power BI, the configuration screens will give general Azure errors. A workaround is to first log in to the Azure portal, complete the MFA challenge and then log into Power BI in the same browser session.
- The following events are intentionally excluded temporarily. This will affect the Query Detail page in the template report (that is, no storage engine subqueries will be visible for now)
The following articles provide more information about Power BI and its many features: