Log analytics M Query export to Power BI - Dates missing

[jovalle]

Hi everyone,

Back in November 2021, I designed and created a few reports for my client in Power BI Desktop by exporting an Azure Log Analytics M query (as shown below) and then copied and pasted it in Power Query Editor using Get Data > Blank Query > Advanced Editor.
I noticed that the dates only go as as far back as 3/10/2022 but begin on todays date 6/8/2022.

Does anyone know why my Nov-Feb records would not be pulled in with this M query? Am I missing something on the limitations when exporting M from Log Analytics?

Thanks so much in advance!

Best, 
JP 

[jovalle]

Thank you so much! That did it! : ) 

Best, 

JP 

[edhans]

Glad to help!

[edhans · Accepted solution]

What is your log retention policy? It may be records before Feb have been purged. Configure data retention and archive in Azure Monitor Logs (Preview) - Azure Monitor | Microsoft Doc...