Table.ExpandTableColumns: Too many requests (427)

Anonymous — Fri, 11 Dec 2020 11:12:28 GMT

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:

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

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

= 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.

Re: Table.ExpandTableColumns: Too many requests (427)

lbendlin — Thu, 24 Dec 2020 22:12:21 GMT

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

topic Table.ExpandTableColumns: Too many requests (427) in Developer

Table.ExpandTableColumns: Too many requests (427)

Re: Table.ExpandTableColumns: Too many requests (427)