Hello! I'm hitting a wall when trying to make reports available on the PowerBI cloud service that can have live data refreshed. I have built out several reports on the Desktop version of PowerBI that connect to our CRM software (Aptly) and refresh the data. The API is paginated and only allows for one page to be called at a time, so I use the following methods to get the data we need
1) Function to allow for page number to be called
(Page) =>
let
Source = Json.Document(Web.Contents("board id?x-token=apitoken&page=" & Number.ToText(Page)))
in
Source
2) Query to run the above function up to a certain page count
let
Source = List.Generate(
() => [page = 0, data =functionname( 0 )],
each [page]<150,
each [page = [page] + 1, data = functionname( [page])]),
in
Source
I did try using a gateway to refresh the data, but the error I ran into was that it couldn't refresh a live data feed. It feels like it should be possible to have the live data feed linked, but I haven't quite found a path to make this happen. Am I missing something obvious here, and/or is there another way to build out the data request? Any and all help is appreciated!
Link to API documentation for reference (in case this helps): https://www.getaptly.com/api/
The specific request path we use is the Get Cards path.
