Forum Discussion

julhelp's avatar
julhelp
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper 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
Icon for Microsoft Employee rankMicrosoft 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