Introduction

In this document you will find instructions and samples for how to integrate with Power BI using Qmarket’s API.


Who is this document for?

Customers who have already configured the Qmarkets API and now wish to integrate it with Power BI to seamlessly import Qmarkets data into their reports.


API Authentication

Power BI will authenticate via an API key. Please contact Qmarkets Support to provision an API endpoint secured with an API key and supply you with the generated credential.


A note regarding Subsystems

If your system has multiple subsystems and the default landing page leads to “System Overview”, you will need to add the “subsystem_id” parameter as shown in the examples in Qmarkets REST API document. If this is not the case for your setup, ignore this parameter.


Get the template file

  • You should have received Qmarkets REST API Template from Qmarkets Professional Services or your CSM. If not, we attached it here as well. 
  • Save it somewhere convenient (e.g. Desktop).


Open the template

  1. Double-click the .pbit file (or open it from Power BI Desktop ▸ File ▸ Open).
  2. A Parameters window appears.
  3. Fill in the parameters and click Load


Parameter

What to enter

ApiKey

Paste your personal API key (keep it private).

ApiUrl

Paste the full endpoint URI you want to query.

Example: https://www.qmarkets.net/api/v3/external/users.

Method

Select POST or GET – use whichever the endpoint requires.

ExtraParams

Add any parameters to the query here.

Example: scopes=profile&filters=profile_company eq "Qmarkets"


Tips: 

  • See Qmarkets REST API user manual document for more information.
  • You can switch endpoints later—just reopen Transform data ▸ Manage Parameters.


Grant access

  • Power BI shows an Access Web Content dialog.

  • Select Anonymous (the template already sends your key in the header).
  • Click Connect.

The data now loads, and a table appears in the Fields pane.


Explore your data

  • Drag fields into a visual - dates are real Date/DateTime, numbers aggregate automatically, text shows as categories.
  • Duplicate labels are auto renamed (e.g. “Budget (2)”) so nothing clashes.
  • New fields added by the API will appear automatically on the next Refresh.

Typical starter visuals - examples

Visual

Steps

Ideas per Month

  1. Add a Clustered column chart → drag Submission Date to Axis (choose Month/Year hierarchy) and ID to Values (count).

Total Ideas by Idea Topic

1 Transform data → select the Ideas table.
2 Highlight the Idea Topic column (comma-separated list).
3 Home ▸ Split Column ▸ By Delimiter → Comma (,) → Split into Rows → OK.
4 Transform ▸ Trim (removes leading/trailing spaces).
5 Close & Apply.
6 Insert a Bar chart.
7 Drag Idea Topic (now one topic per row) to Axis.
8 Drag ID to Values → Count. 

Each bar shows how many ideas are tagged with that topic.

Note: Splitting the Idea Topic column into rows keeps everything in the same Ideas table, so no extra relationships are needed - the visual updates automatically on every refresh.


Publish & schedule refresh (optional)

  1. Home ▸ Publish to your Power BI workspace.
  2. In the Power BI Service, open Dataset ▸ Settings.
  3. Parameters – paste your ApiKey, ApiUrl, set Method and ExtraParams (if needed).
  4. Data-source credentials – leave as Anonymous and Save.
  5. Enable Scheduled refresh at the frequency that suits you.


Troubleshooting

Issue

Fix

401 or 403 errors

Verify the ApiKey and that your user has permission for the endpoint.

A field you expect is missing

Click Home ▸ Refresh; the template auto-adds new fields on refresh.

Numbers show as text

The API may be returning them as non-numeric strings (“12 %”, “€5”). Contact Qmarkets support if you need those parsed differently.