AAI - automated log export to MS PowerBI

Peter Stadel 1 Reputation point
2020-06-18T09:28:04.147+00:00

Hello,

is there a way to export custom logs from AAI - Logs to PowerBI automatically?
Normaly i export the Mquery into a textfile and import it back into an empty PowerBI sheet.

Greetings,
Peter

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,331 questions
{count} votes

1 answer

Sort by: Most helpful
  1. bharathn-msft 5,096 Reputation points Microsoft Employee
    2020-06-25T22:58:14.677+00:00

    @Peter Stadel PowerBI adapter has been deprecated. Currently below are the recommended methods of exporting Application Insights data to Power BI.

    • Export Analytics queries. This is the preferred method. Write any query you want and export it to Power BI. You can place this query on a dashboard, along with any other data.
    • Continuous export and Azure Stream Analytics. This method is useful if you want to store your data for long periods of time. If you don't have an extended data retention requirement, use the export analytics query method. Continuous export and Stream Analytics involves more work to set up and additional storage overhead.

    You can refresh the report manually at different intervals, or set up a scheduled refresh on the options page.

    Additional documentation reference.

    Hope this information helps. Please revert back if you have any further queries.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.