Power Query: Azure Management paging with automatic refresh

[JM-CV]

Hello all, 

With the code below, I am tyring to query Azure VMs with pagination and leaving the Host variable fixed in order to be able to autorefresh the data set in Power BI Services.

Currently I am facing two issues: 

1) In the "Data source credentials" section of the dataset in Power BI services, I see "
https://management.azure.com/?api-version=2022-11-01" instead of the URL I hardcoded to sign in with my account ("https://management.azure.com/")

2) It only does 2 iterations as in the third one, the variable skiptoken contains the value it had in the 2nd iteration plus the new one that has been calculated for the next step appended to it. 

Could you please let me know what I am missing and what I am doing wrong ? 

Thank you in advance. 

let
        GetPages = (Path)=>
        let
            Host = "https://management.azure.com/",

            Source = if Text.Contains(Path," ") then 
             Json.Document(
                Web.Contents(
                    Host, 
                    [RelativePath="subscriptions/xxxxxx/providers/Microsoft.Compute/virtualMachines", Query=[#"api-version"="2022-11-01"]]
                ))
           
            else
             Json.Document(
                Web.Contents(
                    Host, 
                    [RelativePath="subscriptions/xxxxxx/providers/Microsoft.Compute/virtualMachines",Query=[#"api-version"="2022-11-01", #"skiptoken"=Path] ]
                )),

            LL= @Source[value],
            Next = Text.Replace(Source[#"nextLink"], Host, ""),
            skiptoken = Text.Replace(Next, "&%24skiptoken=", ""),

            result = try @ll & @GetPages(skiptoken) otherwise @ll
        in
        result,

        Fullset = GetPages(" ")

in
    Fullset