Forum Discussion
Connect to Azure Monitor/Log Analytics Workspace with Service Principal or Managed Identity
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
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.
3 Replies
- AnonymousNot applicable
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.
- lpaulyFrequent Visitor
Hi Anonymous ,
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?
- lpaulyFrequent Visitor
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.