Forum Discussion
Available Parameter-Values for prefer-statement in exported Query from Azure Log Analytics
Hi all,
When you export a query from Azure Log Analytics to PowerBI, such that the corresponding M-Code is generated automatically, there are several parameters quite at the end of the query, e.g.:
,#"x-ms-app"="AAPBI",#"prefer"="ai.response-thinning=true"],Timeout=#duration(0,0,14,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) => { c{0}, c{3}}))
in
Table
in AnalyticsQuery
Does anyone have a clue, what exactly the parameter-value "ai.reponse-thinning=true" behind the "#'prefer'"-statement stands for ?
In the corresponding API documentation for Azure Log Analytics there are a few prefer-options (e.g. "include-statistics=true", etc.), however there is nothing written about the option ai.response-thinning=true...
Also, there has been a similar thread on this topic already. However, the meaning of the specific parameter-values was not clarified.
Looking forward to your responses!
Best regards,
Tom
2 Replies
- v-alq-msftCommunity Support
- Tom_VoeRegular Visitor
Hi Allan (v-alq-msft),
thanks for the hint with the support ticket. I'll let you know the solution if they can help me out.
Best regards,
Tom