AAI - automated log export to MS PowerBI

Peter Stadel 1 Reputation point


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.


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

1 answer

Sort by: Most helpful
  1. bharathn-msft 5,086 Reputation points Microsoft Employee

    @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