Query taking forever to load

[Anonymous]

let
    url = "https://materialplv.es/wp-json/wc/v3/orders",

    get_one = (url as text,n as number) as any =>
    let 
        result = try Table.FromRecords(Json.Document(Web.Contents(url&"?per_page=15&page="&Number.ToText(n)))) otherwise -1
    in 
        result,
    get_em_all = (tabla as table,url as text,n as number) =>
    let
        get_next = get_one(url,n),
        result = if get_next<>-1 then @get_em_all(tabla&get_next,url,n+1) else tabla
    in 
        result,
    Origen = get_em_all(get_one(url,1),url,2)
in
    Origen

This piece of code takes forever to load for something which should be pretty simple. Idk why. also I am suppoused to pass a header called rel with the value "next" to web contents, in order to get the next page instead of trying to build it manually, but when i do I get an error telling me that that paramenter its allowed only when conected anonimously and most of the data I require from that API is only accesible via authentication.

[v-yalanwu-msft]

Hi, @Anonymous ;

The "authentication" is baked into the Power Query code itself through the API key, so setting the authentication method to anonymous works perfectly in Power BI desktop.

Solved: Anonymous access - Microsoft Power BI Community

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I cannot do that, because with anonymous cretentials, the API restricts the access to some necesary data.