log analytics to Power BI and want to schedule refresh without user interaction

[anuxps]

I have a problem that I want to export data from Azure log analytics to Power BI and want to schedule refresh without user interaction. How we can achieve it.

[GilbertQ]

Hi there

When you are in the log analytics explorer there is an option to have to Power Query.

That will then download a file explaining how to use it within Power Query.

You can then get the data into Power Query and then import and schedule a refreshing of data.

Here are more details: https://docs.microsoft.com/en-us/azure/azure-monitor/platform/powerbi

[anuxps]

The question is about the authentication ...how we can authenticate the query to fetch data without using user interactive account.

[GilbertQ · Accepted solution]

Hi there

You can set it up with a user who has got access to log analytics to run the queries.