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
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.
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?
Hi @Andy_D ,
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?
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?
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.
Check out the News & Announcements to learn more.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.