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.
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.
Power BI Connector
Official connector for seamless integration into your Power BI environment. Auto-refreshing dashboards with quarterly GBM updates. No manual data handling.
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.
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.
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.
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 -H "Authorization: Bearer YOUR_API_KEY" \
"https://gbmapi.bl2020.com/dataseries?seriesid=1&country=DE&startyear=2020&endyear=2025"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']}")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}`));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
ToTableMachine-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
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
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.
Setup in 3 Steps
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.
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.