Using Power BI, the task involves calling a Web API list view that returns a list of records using a standard flat list JSON format and for each record having to call to a different API with the selected records id.

The result being a report that shows the following visuals:

1) Table view of the list

When a record is selected in the above list:

2) Populate a detail view with the data from the details view API call

Please verify that you know how to make the second query dynamically (this is critical for the successful completion of the task).

3) Brief documentation that explains the configuration with the relevant technical description and references.

The detailed API calls will be shared when the job has been awarded.