Power BI / Power Query - Create PBIX File with Looped Web/JSON Data
Budget: £10 – £20 GBP
I need a PBIX file to use as an example of how I can connect to a JSON data source using Web API which meets the following criteria.
1. Connects to and pulls JSON data from the Web API which...
2. Uses a `page` and `pageSize` parameter to loop through 10 records at a time, using the `x-total-count` value in the response header
3. Uses "Incremental Refresh" to pull altered data based upon a `modifiedDate` URL parameter to only pull data since the last time it was refreshed
The endpoint is documented using Swagger and a Postman Collection. The sample endpoint can be seen at https://portal-dev.k3imagine.com/gw-bi/swagger using the /customers endpoint
It uses an `Authorization` header with a Bearer token. This token value must be editable somewhere in the Power Query window. This token will be provided to you.
The project deliverable is a working PBIX file which demonstrates this in action.
1. Connects to and pulls JSON data from the Web API which...
2. Uses a `page` and `pageSize` parameter to loop through 10 records at a time, using the `x-total-count` value in the response header
3. Uses "Incremental Refresh" to pull altered data based upon a `modifiedDate` URL parameter to only pull data since the last time it was refreshed
The endpoint is documented using Swagger and a Postman Collection. The sample endpoint can be seen at https://portal-dev.k3imagine.com/gw-bi/swagger using the /customers endpoint
It uses an `Authorization` header with a Bearer token. This token value must be editable somewhere in the Power Query window. This token will be provided to you.
The project deliverable is a working PBIX file which demonstrates this in action.