OData services. Read cloud agents for Power BI reporting

Good day all

I have been using the following endpoints to retrieve data from Azure Devops

https://analytics.dev.azure.com/{org}/_odata/v3.0-preview/Pipelines

{
	ProjectSK: 5f03fcfd-0000-0000-000-c45092c395dc,
	PipelineSK: 1277,
	PipelineId: 4,
	PipelineName: BackOffice,
	PipelineVersion: 2,
	PipelineProcessType: Yaml
}

https://analytics.dev.azure.com/{org}/_odata/v3.0-preview/PipelineRuns

{
	ProjectSK: 5f03fcfd-0000-0000-0000-c45092c395dc,
	PipelineRunSK: 877,
	PipelineRunId: 94,
	PipelineId: 19,
	PipelineSK: 50,
	BranchSK: 503224,
	RunNumber: 5.23.6.13094-AzurePipelines,
	RunNumberRevision: 1,
	RunReason: Schedule,
	RunOutcome: Succeed,
	QueuedDate: 2019-12-14T00:00:00+02:00,
	QueuedDateSK: 20191214,
	StartedDate: 2019-12-14T00:00:15+02:00,
	StartedDateSK: 20191214,
	CompletedDate: 2019-12-14T00:09:01+02:00,
	CompletedDateSK: 20191214,
	RunDurationSeconds: 526.326,
	QueueDurationSeconds: 14.651,
	TotalDurationSeconds: 540.977,
	SucceededCount: 1,
	PartiallySucceededCount: 0,
	FailedCount: 0,
	CanceledCount: 0
}

Can we retrieve the associated agent pool that executed the pipeline run using the existing odata feeds?

We have a requirement to display the capacity of the Cloud agents on a Power BI dashboard.

I am able to retrieve this information using

https://dev.azure.com/{org}/_apis/distributedtask/pools/9/jobrequests.

However this end point only returns 500 entries on each request and requires me to persist the information in a database to maintain history 😞

Any assistance would be highly appreciated.