Forum Discussion

Tom_Voe's avatar
Tom_Voe
Regular Visitor
5 years ago

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-msft's avatar
    v-alq-msft
    Community Support

    Hi, Tom_Voe 

     

    I haven't found some information about the meaning of the specific parameter-values. You may create a support ticket here for further help.

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Tom_Voe's avatar
      Tom_Voe
      Regular 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