Power BI / Data API

Integrations · API & custom work · 2.2

Gfacility’s Data API exposes live data to Power BI or any other reporting tool. For Power BI we provide standard templates you can use as a starting point. What you see in the API depends on your permissions — the token inherits the rights of the account that generates it.

1. Generate an access token

The API authenticates with a personal access token (PAT). Create one first via your profile settings — see Personal Access Token.

2. Available endpoints

Dataset	Endpoint
Locations	/api/v1/report/power-bi/services/locations
Organizations	/api/v1/report/power-bi/services/organizations
Ratings	/api/v1/report/power-bi/services/ratings
Events	/api/v1/report/power-bi/services/events
Catering	/api/v1/report/power-bi/services/catering
Finance	/api/v1/report/power-bi/services/finances
Tickets	/api/v1/report/power-bi/services/tickets
Tasks	/api/v1/report/power-bi/services/tasks

Full URL = https://app.gfacility.com + endpoint. Headers:

Authorization: <your-token>
Content-Type: application/json

3. Getting started in Power BI

1. Power BI Desktop

Download Power BI Desktop. Together with your token we provide a template file that calls the standard tables.

2. Build reports

Visualise KPIs, dashboards and trend analyses on the linked datasets.

3. Publish

Publish to app.powerbi.com and share within your organisation. Note: reports show the same data to everyone — that of the account the token was created with.

4. Automatic refresh

Configure refresh in the dataset settings. The number of refreshes per day depends on your Power BI licence.

4. Setting up automatic refresh

In Power BI online: open the dataset → three dots → Settings.

Data source credentials — for each row click “Edit credentials”:

Authentication method: Anonymous
Privacy level: None
Skip test connection: tick

Refresh — choose the desired refresh frequency. You can then optionally have reports delivered by email through subscriptions.

← Previous Next: Custom integrations→