Table.ExpandTableColumns: Too many requests (427)

[Anonymous]

Hello,

I am trying to expand a column containing tables. All the data is being requested via API. When I use Table.ExpandTableColumns, it seems as there are more API requests sent, which puts me over the limiting quota of the service, resulting in an 427 error.

Is there a way to expand columns slower? I tried combining it with Function.InvokeAfter, but I had no luck so far.

Steps:

1: 

= let
 Query = "Machines",
 Source = OData.Feed("https://api.securitycenter.windows.com/api/" & Query, null, [Implementation="2.0", MoreColumns=true])
in
 Source

2:

= Table.SelectColumns(Step1,{"computerDnsName", "software"})

3:

= Table.ExpandTableColumn(Step2, "software", {"name", "vendor"}, {"software.name", "software.vendor"})

= Function.InvokeAfter(()=> Table.ExpandTableColumn(Step2, "software", {"name", "vendor"}, {"software.name", "software.vendor"}), #duration(0,0,0,2))

Thank you guys in advance. If you need more information, feel free to ask.

[lbendlin]

Since you already know which columns you need, why not specify them in the ODATA query string?