Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Convert a value of type Record to type Text

Dears,  I have connect to my API to retrieve data and each request give me 50 in a page so i built this but for a reason it give me an error      Expression.Error: We cannot convert a value of t...
  • mahoneypat's avatar
    5 years ago

    In case it helps, FYI that I just put out a video on using REST APIs with power query.  It shows how to get the count and use it to create a list of numbers to make multiple calls with $skip or offset to get all the data (so don't have to worry about pagination).

    Power BI - Tales From The Front - REST APIs - YouTube

     

    Regards,

    Pat