Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
2 years ago

Power Query - Blank Query - API Call Service Refresh

I have this piece of code where I call external API to get some data but an issue I am having is that once I publish this to Power BI service if fails to refresh you to dynamic data source etc. Howev...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

Remove the question mark from RelativePath

 

is the query parameter called start or offset?

stribor45's avatar
stribor45
Post Prodigy
2 years ago

is this something that cant be solved by power query? I have tried removing pieces of the URL and adding it to relative path in hope that it would work to no luck. anything else i can try?

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Show what you have tried, and what error message you got.

    • stribor45's avatar
      stribor45
      Post Prodigy
      2 years ago
      let
    headers = [#"Content-Type" = "application/json", #"Accept"="application/json"],
    getJson = (url) => 
      let
          Source = Json.Document(Web.Contents(url, [RelativePath = "api/v2/pokemon", 
                                                    Query=[limit="100", offset="0"], Headers = headers]))
      
      in 
        Source,
    
    data = getJson("https://pokeapi.co")
in
    data

      I dont have an error per say but what I do get is error in service that this cant be refreshed.

       

       

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        Is 

        https://pokeapi.co

        a valid URL that returns a http 200?