Extracting Cursor-based API Data in Power BI Without External Tools | Power Query & M Tutorial

Поділитися
Вставка
  • Опубліковано 21 жов 2024

КОМЕНТАРІ • 4

  • @jackrush112
    @jackrush112 17 днів тому +1

    Thanks for this.
    The pagination url on the API I'm using is only a partial URL, essentially the back half of the original URL query. So I'm struggling to pull the next pages in.
    My first thought was to store the baseURL as the parameter, then append the initial query to it. Then when pulling the next cursor I append the Next to the baseURL parameter. Not sure how to go about this in the query, though - any ideas?

    • @introverted.manager
      @introverted.manager  13 днів тому

      If I understood correctly, RelativePath function in M might help with that.
      I have video about it.

    • @jackrush112
      @jackrush112 13 днів тому

      @@introverted.manager thank you for the recommendation. I was already using relative path, I just couldn't figure out why calling the next cursor wasn't working. Turns out the API is broken 🙃
      Not all bad news though, it lead me to your channel that has some great info on it.

    • @introverted.manager
      @introverted.manager  13 днів тому +1

      Glad you were able to narrow it down 😉