←Back
Power BI
Power BI Connector
Official connector for seamless integration of GBM data into your BI tool. Installation in just a few minutes.
System Requirements
✓Power BI Desktop (Version 2.0 or higher)
✓Windows 10/11 or macOS (with Power BI Desktop)
✓Active GBM API key (Professional Tier or higher)
✓Internet connection for data refresh
Installation: Step by Step
1
Download Connector
2
Install Connector
Copy the .mez file to the Custom Connectors folder:
C:\Users\[YourUsername]\Documents\Power BI Desktop\Custom Connectors\Note: If the "Custom Connectors" folder does not exist, create it manually.
3
Adjust Security Settings
Enable Custom Connectors in Power BI Desktop:
- Open Power BI Desktop
- Go to File → Options and Settings → Options
- Select Security in the left menu
- Under "Data Extensions" select "(Not Recommended) Allow any extension to load without validation or warning"
- Click OK
- Restart Power BI Desktop
Security note: This setting allows loading Custom Connectors. Only load connectors from trusted sources.
4
Establish Connection
Connect to the GBM API:
- Click Get Data
- Click "More..."
- Scroll or search for "GBM API"
- Select Power BI GBM API Connector
- Click Connect
- If prompted, enter your API key
- Enter "https://gbmapi.bl2020.com" as the baseURL
- Click OK
5
Load Data Series
The connector provides three functions:
- View all existing data series as a table
- Query a single data series as a function
- Query multiple data series as a function
To load multiple data series (example):
- Click Transform Data
- The Power Query Editor opens, a query is created and a table is displayed.
- Click "Function" in the "Multiple Series" row in the "Data" column
- Enter query parameters, e.g. 57,58,59 for "seriesids", DE,AT,CH for "countries", 2020 for "startyear" and 2025 for "endyear"
- Click OK
- Click Close & Apply
Troubleshooting
Connector Not Displayed
- Verify the .mez file is in the correct folder
- Make sure Power BI Desktop has been restarted
- Check the security settings (Step 3)
Authentication Error
- Verify your API key is correct
- Ensure your API key has not expired
- Check if your tier allows Power BI access (Professional+)
Data Not Updating
- Click "Refresh" in Power BI
- Check your internet connection
- Verify you have not reached your rate limit
- For Power BI Service: Configure a gateway for scheduled refreshes
Need Help?
Our team is happy to help you with installation and configuration.
Your contact
Jens Wehenkel
GBM & Data Connectivity
+49 228 62987-33
Show email
Patrick Nonnen
APIs, Power BI & SDKs
Show email