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

แชร์
ฝัง
  • เผยแพร่เมื่อ 17 พ.ย. 2024

ความคิดเห็น • 4

  • @jackrush112
    @jackrush112 หลายเดือนก่อน +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  หลายเดือนก่อน

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

    • @jackrush112
      @jackrush112 หลายเดือนก่อน

      @@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  หลายเดือนก่อน +1

      Glad you were able to narrow it down 😉