export the app insight query log and store it in to the table

[PBILover]

Hi

I want to create the dashboard on the historical data of app insight query log. my organizations retention policy is only last 90 days. but i want to create the dashboard based on last 1 year data. is it possible for us to create achieve this in a power BI?

is it possible to export the app insight query log and store it in to the table and then create the dashboard on it?

Lookinng for the solution to create a dashboard which will show last 1 year of data.

Thanks

[v-jianpeng-msft]

Hi, @PBILover 

You can store Application Insights query logs to Azure Data Lake Storage or Azure Blob Storage. You can then create a dashboard using Azure Data Lake or Azure Blob. The following article will guide you on how to export Application Insights query logs to Azure SQL Database:

How to copy logs from Application Insights into an Azure SQL Database using Azure Data Factory | by ...

In addition, you can refer to the following articles:

Log Analytics integration with Power BI and Excel - Azure Monitor | Microsoft Learn

Explore your Application Insights data with Power BI | Microsoft Power BI Blog | Microsoft Power BI

Connect to Application Insights and Log Analytics with Direct Query in Power BI – The White Pages (b...

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PBILover]

Thanks @v-jianpeng-msft .

I went through this, is it possible to achieve this by using incremental dataset refresh?

We can get the data from the app insight for last 90 days and implement the incr dtaset refresh policy which will store last 1 year data?

Thanks

[v-jianpeng-msft · Accepted solution]

Hi, @PBILover 

Thank you very much for your reply. Yes, if you set a policy for a year. The prerequisite is that you must successfully incrementally refresh once.

I guess you need to know about the sliding window mode:

Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

As long as your data is in the history or refresh partition, it will not be deleted from the semantic model.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.