Connect to Azure Monitor/Log Analytics Workspace with Service Principal or Managed Identity

[lpauly]

Hello everybody,

I want to connect to a Azure Log Analytics workspace with Power BI, I know that I can get the M-Query via export from the query desinger: https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-powerbi . 

But because of security reasons I need to connect not with my own user in azure but with either a service principal or with a managed identity. Is there any possibility to do so? Or is there another way, or best practise for not using a personal azure account? 

Kind Regards

Lucas

[lpauly · Accepted solution]

Hi,

I found a solution from this Blog: https://powers-hell.com/2021/08/15/authenticate-to-graph-directly-from-powerbi/

With this and a Service Principal I can get data.

[v-stephen-msft]

Hi @lpauly ,

There's an official document about using Azure Log Analytics in Power BI, please kindly refer to

Using Azure Log Analytics in Power BI (Preview) - Power BI | Microsoft Learn

Be aware of the considerations and limitations.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lpauly]

Hi @v-stephen-msft ,

Unfortunately, this is the wrong direction. We need the Data from an Azure Log Analytics Workspace in Power BI. Is this possible without dedicated User?