Report on Gluu data in PowerBI

Goal: Retrieve Gluu data via API and build PowerBI reports—no coding required.

Requirements before starting:

1. PowerBI Desktop for Windows.
2. Manage account rights in Gluu.

Intro video #

Step 1: Find the data in Gluu #

Click Manage account (lower left). Open API browser to see all available queries.

If you don’t see it, request the Manage account right.

Browse queries, then open one to preview its output.

Step 2: Get the URL and token #

Click Get Query to copy the URL and an access token.

Token note: Tokens rotate for security. When it changes, refresh your PowerBI connection.

Step 3: Fetch data in PowerBI #

1. In PowerBI, click Get data > Web.
2. Choose Advanced.
3. First URL part = the URL from Gluu.
4. Second URL part = ?access_token=[your-token] (do not include the word “Bearer”).
5. Check the URL preview, then click OK.

Step 4: Power Query Editor #

PowerBI opens the editor with your data in a table view. Rename the query to something clear (e.g., All cases) and click Close & Apply.

Step 5: Visualize the data #

1. Go to Report.
2. Add a Table visual.
3. Open the All cases dataset and check caseName.