Forum Discussion

julhelp's avatar
julhelp
Helper I
4 years ago
Solved

REST api request in Power Query more than 1000 records

Hi,   i am facing the challange of requesting data from a REST service that limits the records by 1000. But i have data with more than 100.000 records. I am pretty new in power bi but my idea was t...
Need Help
  • julhelp's avatar
    julhelp
    Helper I
    4 years ago

    Thanks this was the video i searched for hours 🙂 

     

    My next problem is, that i am getting my data but as record. So there is an error massage saying:  

    Expression.Error: We cannot apply operator & to types Record and Text.
    Details:
    Operator=&
    Left=[Record]
    Right=&limit=1000&offset=

     

    so i dont know how du convert the [Record] in my Web.Contents to text.

     

    this is my changed code so far:

     

    and this my whole code: 

     

     

    • mahoneypat's avatar
      mahoneypat
      Microsoft Employee
      4 years ago

      That error is because your are combining the Headers record with the "&limit= ..." text. You need to provide the info in that record in the same way as the limit and offset.

       

      ...?x-P4t-Auth-User=" & Username & "&x-P4t=" & AuthToken & "&limit= ...

       

      Alternatively, you can provide the limit and offset in the first term of Web.Contents

       

      Web.Contents(BaseUrl & "/" & tabellaname & "limit=1000&offset=" & [Column1], ...)

       

      Pat