Back
Direct integrations

Connectivity

Market data that integrates seamlessly

GBM data flows directly into your existing tools — Power BI, Excel, or any application via REST API. No new interface. No manual work. Always up-to-date with quarterly releases.

Less
Time spent on data preparation
Fast
Implementation time
No
Training required
12
Dashboard templates

Four ways to use GBM data

Choose the integration that fits your workflow. Or use all four. Every method connects to the same data source and updates automatically with each quarterly release.

REST API

Full programmatic control. Integrate GBM data into any application, database, or internal tool. Build custom dashboards, feed forecasting models, or automate reporting pipelines.

RESTful JSON endpoints for all GBM data series
OpenAPI spec for automatic client generation
Code examples in cURL, Python, JavaScript & Power Query
Bearer token authentication
Query single or multiple dataseries by country & time range

Power BI Connector

Official connector for seamless integration into your Power BI environment. Auto-refreshing dashboards with quarterly GBM updates. No manual data handling.

Direct connection to GBM API from Power BI
Automatic updates — dashboards always current
All metrics & countries available
Scheduled refreshes possible
No coding required

Living Excel

Self-updating spreadsheets that refresh automatically when new GBM data is published. Built on Power Query — no VBA, no macros. Works with Excel 2019+ and Microsoft 365.

Ready-to-use Excel file for download
Power Query M-Code included
No VBA, no macros — pure Power Query
Setup in less than 2 hours
Refresh with Ctrl+Alt+F5

Dashboard Templates

12 pre-built analyses for Power BI and Excel. Country comparison, trend analysis, market sizing, building type breakdown — ready to use, fully customizable.

12 pre-configured dashboard templates
Available for Power BI and Excel
Best-practice visualizations
Fully customizable to your needs
Regular updates with new templates
Market overview, building types, regional comparison

The right solution for every role

For Executives

Faster decisions through auto-updated dashboards. Higher adoption without training effort. Lower IT costs.

For Analysts

From raw data to insights in minutes. 12 dashboard templates. Living Excel. Automatic calculations.

For Developers

REST API. SDKs for Python and JavaScript. Comprehensive documentation. Up and running in 30 minutes.

REST API

RESTful. Developer-friendly. Production-ready.

RESTful API with interactive documentation. Bearer-token authentication. OpenAPI spec available for client generation.

Quick Start: Your First API Call

cURL
curl -H "Authorization: Bearer YOUR_API_KEY" \
  "https://gbmapi.bl2020.com/dataseries?seriesid=1&country=DE&startyear=2020&endyear=2025"
Python
import requests

response = requests.get(
    "https://gbmapi.bl2020.com/dataseries",
    headers={"Authorization": "Bearer YOUR_API_KEY"},
    params={
        "seriesid": 1,
        "country": "DE",
        "startyear": 2020,
        "endyear": 2025
    }
)
data = response.json()
print(f"Series: {data['seriesname']}, Country: {data['country']}")
for point in data["data"]:
    print(f"  {point['date']}: {point['value']}")
JavaScript
const response = await fetch(
  "https://gbmapi.bl2020.com/dataseries?seriesid=1&country=DE&startyear=2020&endyear=2025",
  { headers: { "Authorization": "Bearer YOUR_API_KEY" } }
);
const data = await response.json();
console.log(`Series: ${data.seriesname}, Country: ${data.country}`);
data.data.forEach(p => console.log(`  ${p.date}: ${p.value}`));
Power Query M (for Excel / Power BI)
let
    Source = Json.Document(
        Web.Contents("https://gbmapi.bl2020.com/dataseries", [
            Headers = [Authorization = "Bearer YOUR_API_KEY"],
            Query = [seriesid = "1", country = "DE", startyear = "2020", endyear = "2025"]
        ])
    ),
    ToTable = Table.FromRecords(Source[data])
in
    ToTable

Machine-readable OpenAPI specification available at /openapi

RESTful JSON Endpoints

Clean, well-structured JSON responses for all GBM data series. Query single or multiple dataseries by country and time range.

OpenAPI Specification

Machine-readable OpenAPI spec available for automatic client generation in any language. Generate type-safe clients with standard tooling.

Interactive Docs

Interactive API documentation, request/response schemas, and parameter descriptions for every endpoint.

Catalog & Metadata

Browse available catalogs, series, frequencies, and units via dedicated endpoints. Filter dataseries by catalog attributes to find exactly the data you need.

Bearer Token Authentication

Simple Bearer token authentication. API key provisioned directly in the MILAN Portal with your Continent or Global package.

Flexible Queries

Request single or multiple dataseries at once. Filter by country, year range, and month range. Retrieve data for multiple countries and series in a single call.

🔑

API Key Provisioning

An API key is provided directly in the MILAN Portal once you have booked a package starting from Continent. API access is included in the Continent and Global packages. No additional cost for API usage.

Available API Endpoints

GET/dataseriesSingle dataseries for a specific country and date range
GET/dataseries/multipleMultiple dataseries for combinations of series IDs and countries
GET/dataseries/catalogFilter dataseries by catalog, series, frequency, or unit
GET/dataseries/catalog/{seriesid}Metadata for a specific dataseries
GET/catalogsList all available catalogs
GET/seriesList all available series names
GET/frequenciesList all available frequencies
GET/unitsList all available units

Official Power BI Connector

Seamless integration into your Power BI environment. Auto-refreshing dashboards with quarterly GBM updates. No manual data handling, no coding required.

Setup in 4 Steps

1
Install Connector
Download the official GBM connector from the Power BI marketplace or install the .mez file manually.
2
Enter API Key
Enter your GBM API key in the connector settings. Key is provisioned in your MILAN Portal.
3
Select Data
Choose countries, building types, and metrics. The connector loads all available GBM data series.
4
Auto-Refresh
Configure scheduled refresh in Power BI Service. Dashboards update automatically with every quarterly GBM release.
GBM Database
170 countries, quarterly updates
Power BI Connector
Official, certified
Your Dashboard
Always up-to-date

Direct API Connection

The connector communicates directly with the GBM API. No intermediate files, no manual exports. Data flows from our database to your dashboard.

Automatic Updates

When GBM publishes new quarterly data, your dashboards update automatically on the next scheduled refresh. No action required.

All Metrics & Countries

Access every GBM data point: permits, completions, volumes, macro drivers — for all 170 countries. Filter and combine as needed.

Scheduled Refreshes

Configure daily, weekly, or custom refresh schedules in Power BI Service. Ideal for automated reporting workflows.

No Coding Required

Point-and-click setup. Select countries and metrics from dropdown menus. Build dashboards using the standard Power BI interface.

Works with Power BI Service

Full support for Power BI Desktop and Power BI Service. Publish dashboards to your organization and share with colleagues.

Living Excel — Self-Updating Spreadsheets

Self-updating Excel templates that refresh automatically when new GBM data is published. Built entirely on Power Query — no VBA, no macros. Works with Excel 2019+ and Microsoft 365.

How Living Excel Works

Living Excel uses Power Query M-Code to connect directly to the GBM API. When you press Ctrl+Alt+F5, Excel pulls the latest data from our servers and updates all tables and charts. No VBA scripts, no macros — just native Power Query that works reliably in every Excel version since 2019.

Power Query
Built on native Excel technology
Zero VBA
No macros, no security warnings
< 2h
Setup time from download to first refresh

Setup in 3 Steps

1
Download Template
Download the ready-to-use Living Excel template from the MILAN Portal. Includes all Power Query connections pre-configured.
2
Enter API Key
Open the Power Query editor and paste your API key into the parameter field. One-time setup, stored securely in the workbook.
3
Refresh & Use
Press Ctrl+Alt+F5 to pull the latest GBM data. All tables, charts, and pivot tables update automatically. Works offline after initial load.

Ready-to-Use Template

Download and start immediately. Pre-configured Power Query connections for all GBM data series.

Power Query M-Code

All data connections use native Power Query M-Code. Fully transparent, editable, and extensible.

No VBA, No Macros

Pure Power Query — no security warnings, no macro permissions needed. IT-friendly and audit-compliant.

Excel 2019+ & M365

Compatible with Excel 2019, 2021, and Microsoft 365. Works on Windows and Mac (M365).

Works Offline

After initial data load, the spreadsheet works fully offline. Refresh when you need updated data.

Customizable Queries

Modify Power Query parameters to select specific countries, building types, or time periods. Adapt to your exact needs.

12 Pre-Built Dashboard Templates

Production-ready analyses for Power BI and Excel. Country comparisons, trend analyses, market sizing, building type breakdowns — ready to use, fully customizable to your needs.

01European Market Overview
02Country Deep Dive
03Building Type Comparison
04Residential vs Non-Residential
05Permit Trend Monitor
06Completion Tracker
07Volume Forecast Dashboard
08Macro Driver Analysis
09Regional Comparison
10YoY Growth Analysis
11Market Sizing Tool
12Executive Summary

Power BI & Excel

Every template is available in two formats: as a .pbix file for Power BI Desktop and as a Living Excel workbook. Choose the tool your team prefers.

Best-Practice Visualizations

Designed by data visualization experts. Each template follows best practices for construction market analysis — clear, actionable, presentation-ready.

Fully Customizable

Every template is fully editable. Add your company branding, modify charts, add new pages, combine with your internal data sources.

Regular Updates

We continuously add new templates based on customer feedback. Existing templates are updated with improved visualizations and new features.