AG5 API & PowerBI - User Guide

Many customers want to connect AG5 API to BI tools, mainly Power BI. Since we often get a few questions about this, we prepared a short user guide to help you get started.

Important: this is just a user guide. We don't provide consultancy or support for customer BI setups.

---

This guide includes:

• Step-by-step instructions

• Images

• One full tutorial video

1

Step 1: Open Power BI

1. Go to Get Data

2. Select Web

3. Then choose Advanced

2

Step 2: Enter API details

In the URL parts section:

• Use the base URL from the AG5 API specification

• Add the endpoint you want to query (for example, /groupings)

In the HTTP request header parameters section, add:

• X-API-Key → <your API key>

• Accept → */*

Click OK.

3

Step 3: Authentication

When prompted, select Anonymous as the authentication method.

4

Step 4: Pagination in Power BI

Some AG5 API endpoints include pagination fields, such as:

• pagination.total

• pagination.nextCursor

• pagination.hasMore

This means data may be split across multiple pages. Power BI’s PowerQuery (M) can be used to loop through the pages and retrieve all records.

If you only need the first page of results, no extra steps are needed. If you need all results, a PowerQuery script must be used. You may choose to build this script, use AI or ask your BI specialist for help.

5

Step 5: Load Data

Click Load in Power BI to import the data. You can now use Power BI’s full range of reporting and visualization tools on your AG5 data.

522KB

AG5 API → PowerBI _ User Guide.pdf

pdf

Here is our user guide in PDF format.

21MB

POWERBITUTORIALFINAL.mp4

Here is our brief, tutorial video.