About Update Failure of Log Analytics Report

Question

I get logs from Log Analytics, create graphs in Power BI and update regularly.However, the refresh began to fail irregularly two weeks ago.This phenomenon is happening in various reports I have. Is there anyone who knows the cause?Message:Web.Contents failed to get contents from 'https ://api.loganalytics.io/v1/workspaces/&nbsp;.../query?query=OfficeActivity...' (502): Bad Gateway Table: LogAnalytics.M Querylet jp_timezone = (x as datetimezone) as datetimezone =&gt; DateTimeZone.SwitchZone(x, 9),
AnalyticsQuery =
let Source = Json.Document(Web.Contents("https://api.loganalytics.io/v1/workspaces/...../query", 
[Query=[#"query"="OfficeActivity
| where ( OfficeWorkload == ""OneDrive"" or OfficeWorkload == ""SharePoint"")
",#"x-ms-app"="OmsAnalyticsPBI",#"prefer"="ai.response-thinning=true"],Timeout=#duration(0,0,10,0)])),
TypeMap = #table(
{ "AnalyticsTypes", "Type" }, 
{ 
{ "string",   Text.Type },
{ "int",      Int32.Type },
{ "long",     Int64.Type },
{ "real",     Double.Type },
{ "timespan", Duration.Type },
{ "datetime", DateTimeZone.Type },
{ "bool",     Logical.Type },
{ "guid",     Text.Type },
{ "dynamic",  Text.Type }
}),
DataTable = Source[tables]{0},
Columns = Table.FromRecords(DataTable[columns]),
ColumnsWithType = Table.Join(Columns, {"type"}, TypeMap , {"AnalyticsTypes"}),
Rows = Table.FromRows(DataTable[rows], Columns[name]), 
Table = Table.TransformColumnTypes(Rows, Table.ToList(ColumnsWithType, (c) =&gt; { c{0}, c{3}}))
in
Table,.......&nbsp;

v-yuta-msft · Answer

Anonymous&nbsp;,
&nbsp;
Please check if the Azure credentials is still valid or expired.
&nbsp;
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

anonymous · Answer

Hi&nbsp;v-yuta-msft&nbsp;Thanks for the reply.I have verified my credentials but they have not expired.If the Azure credentials have expired, then all of the report refreshes should have failed.When the report refresh is successful, I can check the latest log.I would like to apologize for my poor English.

Forum Discussion

2 Replies