Azure Log analytics authentication query

Question

Morning all, I have tried searching for an answer but cant find one to help so hoping the experts here can point me in the right direction.

I have created a simple dashboard that is used to generate numbers for a weekly stats report and I have published it to an internal area so the team creating the weekly report can see it. However their credentials do not have permissions to refresh the data as they do not have accounts over the Azure tenants where the data is coming from.

The queries behind the data are imported directly from Kusto queries in Azure Log Analytics using my credentials to authenticate so I need to find a way to provide some alternative "generic" method of authentication. Is this possible with e.g. api keys or similar conencting to the log analytics workspace?

thanks in advance

v-lid-msft · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Based on this document, we can configure the scheduled refresh to keep your data up to date. If you are looking for the access control of credentials, please refer to this document.&nbsp;Best regards,Community Support Team _ Dong LiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Thanks but it hasnt quite helped,&nbsp;I'm OK with the RBAC roles and scheduled refresh - I'm more after how to use a "non-user" account to do the refresh itself.I need to use a set of credentials to refresh the data that are not linked to a user account with an expiring password.&nbsp;is there a way of using e.g. an application service principal or the storage account keys themselves somehow?Andy

adamlen · Answer

Hi Andy,&nbsp;I'm after the same the same setup, connecting to Log Analytics Workspace using a M query and authenticating with a azure service principal.Were you able to find a way to do it?&nbsp;Adam

anuxps · Answer

Any luck to resolve this issue. I also have same problem that I want to export data from log analytics to Power BI and want to schedule refresh with user interaction. How we can achieve it.

muzzar78 · Answer

We too are experiencing this same issue. We need to be able to use a service principal for the scheduled refresh but haven't found anyway to do it. Has anyone found a solution?

Forum Discussion

Azure Log analytics authentication query

8 Replies

Related content

Google Analytics GA4 Authentication Error

Fabric vs Azure Synapse Analytics

Fabric + Azure Log Analytics (Azure Monitor)

Fabric & Azure Data User Group Program Requirements & Benefits

Using Managed Identity for Fabric Lakehouse SQL Analytics Authentication