Monday, December 6, 2021

How to setup Azure Log Analytics for Power BI workspace

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. 

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.

An Azure Log Analytics connection is currently supported for Premium workspace in Power BI. You must configure this at the workspace level as shown below.

Must be allowed by the tenant administrator under Tenant settings

Before configuring this, you must create a Log Analytics Workspace and assign the owner role for Power BI Service app.

Once you configure the Log Analytics for a workspace, the data will be available in 5 minutes. Click on Locks in Log Analytics in Azure Portal and run your queries.

You can see there is table called PowerBIDatasetsWorkspace

You can run a KQL query and analyze the data, the following query is showing count. Kusto Query Language is a powerful tool to explore your data and discover patterns, identify anomalies and outliers, create statistical modelling, and more.

 

You can also use pre-defined queries and modifies as per your requirements

 

In addition to this, you can download power bi report templates from Microsoft. All you need just provide the parameter values and publish them in Power BI service.


Please read here for more details

https://docs.microsoft.com/en-us/power-bi/transform-model/log-analytics/desktop-log-analytics-overview

https://docs.microsoft.com/en-us/azure/data-explorer/kusto/query/

Cheers!
Uma