cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DolEgon22
Helper II
Helper II

31 Days of Log Analytics Data

We're using Power BI to visualize data from Azure Log Analytics (using the M query export feature in Log Analytics). The workspace we are using is set to keep 62 days of data. When I query the data in Log Analytics, I see data up to 62 days old. 

 

However, in Power BI, I am only getting 31 days worth of data.

 

I have even updated my query to include:

 

| where TimeGenerated > ago(62d)

This doesn't do anything--I consistently only get 31 days of data. 

 

Also, this is happening with a large dataset (93000 rows) and a small dataset (9500 rows), so it doesn't appear to be a row limit. 

 

Is this a limitation in Power BI? Is there a way around it?

1 ACCEPTED SOLUTION

Found the issue--query was pointing to a development workspace. Smiley Frustrated

View solution in original post

4 REPLIES 4
v-juanli-msft
Community Support
Community Support

Hi @DolEgon22

According to this article, For the Standalone or Paid tier, data collected in Log Analytics is available for the last 31 days.

 

Best Regards

Maggie

Here is the rowcount when using 62 days in Log Analytics:

 

loganalytics62.png

 

Here is the M query for Power BI:

 

mquery62.png

 

 

...and the resulting rowcount in Power BI:

 

mquery62_2.png

 

 

Found the issue--query was pointing to a development workspace. Smiley Frustrated

View solution in original post

OK I'll clarify--we're using OMS as the data source. While this is technically Log Analytics, it can be configured for data beyond 31 days, which we have. Power BI does not see data beyond 31 days even though the query has no time limit set. In fact, even if I set it to:

"timespan"="P62D"

 

I still only get 31 days. 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors