Azure 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.

[edhans]

Scheduling the refresh is simple. Seems you have to do 3 things:

1. Automate the export of the Azure Analytics log - you should probably ask how to do this on an Azure forum unless someone here by chance knows how to do that.
2. Automate the moving of that file to an online SharePoint libarary or Azure Data Lake - Power Automate can do the former, not sure about the latter.
3. Write your Power BI report against the files in that SP library or Azure DL, publish it, and set up the scheduled refresh.

#3 does not require a gateway, but #2 might depending on where #1 drops the file.

[anuxps]

problem is not scheduling .... problem is authentication and authorization....