cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

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

Hi there

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

3 REPLIES 3
Highlighted
Super User IV
Super User IV

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

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
Microsoft
Microsoft

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

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

Highlighted
Super User IV
Super User IV

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

Hi there

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors