Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
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)?
let
url = "https://api.samplewebpage.com/api/v1/transactions?offset=1&limit=50",
Source = Json.Document(Web.Contents(url,[Headers = [#"X-Api-Token"="sdfkjslkjvsivjsoifvjdfvdfljsl"] ] ))
in
Source
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 2 | |
| 2 |