https://community.fabric.microsoft.com/t5/Developer/Pull-data-from-an-API-using-power-query/m-p/581893#M17862 <P>Hi,</P><P>I'm trying to pull a data from an API using power query. My request is successful, but problem is that there is a limit on the number of objects to be returned per request (50 rows). So every time I refresh my data I get the latest 50 rows and all the previous data is deleted. How can I modify my request in PwQ to aggregate the data (latest information added to previously loaded)?</P><P>&nbsp;</P><P>let<BR />url = "<A href="https://api.samplewebpage.com/api/v1/transactions?offset=1&amp;limit=50" target="_blank">https://api.samplewebpage.com/api/v1/transactions?offset=1&amp;limit=50</A>",<BR />Source = Json.Document(Web.Contents(url,[Headers = [#"X-Api-Token"="sdfkjslkjvsivjsoifvjdfvdfljsl"] ] ))<BR />in<BR />Source</P> Sat, 08 Dec 2018 21:11:01 GMT Kalvis 2018-12-08T21:11:01Z https://community.fabric.microsoft.com/t5/Developer/Pull-data-from-an-API-using-power-query/m-p/581893#M17862 <P>Hi,</P><P>I'm trying to pull a data from an API using power query. My request is successful, but problem is that there is a limit on the number of objects to be returned per request (50 rows). So every time I refresh my data I get the latest 50 rows and all the previous data is deleted. How can I modify my request in PwQ to aggregate the data (latest information added to previously loaded)?</P><P>&nbsp;</P><P>let<BR />url = "<A href="https://api.samplewebpage.com/api/v1/transactions?offset=1&amp;limit=50" target="_blank">https://api.samplewebpage.com/api/v1/transactions?offset=1&amp;limit=50</A>",<BR />Source = Json.Document(Web.Contents(url,[Headers = [#"X-Api-Token"="sdfkjslkjvsivjsoifvjdfvdfljsl"] ] ))<BR />in<BR />Source</P> Sat, 08 Dec 2018 21:11:01 GMT https://community.fabric.microsoft.com/t5/Developer/Pull-data-from-an-API-using-power-query/m-p/581893#M17862 Kalvis 2018-12-08T21:11:01Z