Re: Available Parameter-Values for prefer-statement in exported Query from Azure Log Analytics

Tom_Voe — Mon, 15 Feb 2021 08:46:43 GMT

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

Available Parameter-Values for prefer-statement in exported Query from Azure Log Analytics

Tom_Voe — Thu, 11 Feb 2021 11:03:53 GMT

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

Tom_Voe Tracker

Re: Available Parameter-Values for prefer-statement in exported Query from Azure Log Analytics

Hi Allan (v-alq-msft),

Available Parameter-Values for prefer-statement in exported Query from Azure Log Analytics