Refresh Power BI dataset connected to Scopus API database

Hi ImkeF 

Thanks for refereing me to the blog address,

but I myself previously followed the recommendation in that blog as you can see in my query 2 at above which I used a relative address for Scopus but finaly it returns a credential error on web refreshing trial. I also tried followig query using header but this one also could not resove the refereshing issue on web.

By the way I think I tried all ways but ineed I am bigneer in PBI and my mind is confused completely for this problem. Thanks anyway...

Query 3

let
    Source =  25, //the total value from a total rows api?
    Starts = List.Generate(()=>0, each _ < Source, each _ + 25),
    #"Converted to Table" = Table.FromList(Starts, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type text}}),
    #"Added Custom" = Table.AddColumn(#"Changed Type", "Custom", each Json.Document(Web.Contents("https://api.elsevier.com/",
          
    [RelativePath="content/search/scopus", Headers = [#"X-ELS-APIKey"="APIKEY" ,#"Accept"="application/json"], 
    Query=[query="AFFIL ( {Environmental Research Center}  OR  {Institute for Environmental Research} )  AND  AFFIL ( {Tehran University of Medical Sciences}  OR  {Tehran University of Medical Science} )",
        view="complete",
        limit="40",
        start="&[Column1]",
        count="25"]])))
in
#"Added Custom"