cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Andy_D
Regular Visitor

Azure Log analytics authentication query

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

7 REPLIES 7
micpol
Frequent Visitor

I have faced the same issue. Any follow-up so far?

lily99
Regular Visitor

Hello,

I want to use the application credential to query Log Analytics REST API, not  my own credential. My issue is very similar with the posts above. Does any PowerBI expert have any direction of how to handle this scenario?

 

Your help is much appreciated.

-ly

muzzar78
New Member

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?

v-lid-msft
Community Support
Community Support

Hi @Andy_D ,

 

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.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks but it hasnt quite helped,

 

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.

 

is there a way of using e.g. an application service principal or the storage account keys themselves somehow?

Andy

Hi Andy,

 

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?

 

Adam

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.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.