Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Log analytics M Query export to Power BI - Dates missing

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