Can I use Metricool with Power BI?
How to connect Metricool with Power BI using the API
If you work with Power BI and need to visualize your Metricool metrics, you can do it through our API.
You can set up queries to fetch data directly from the Metricool API and build dynamic reports in Power BI.
What you need
- A Metricool account with access to the Metricool API
- Power BI Desktop installed
- Basic knowledge of Web/API queries and data modeling
What data can you access
The Metricool API allows you to access data from various parts of your account, such as:
- Social media stats (followers, interactions, posts)
- Ad campaign metrics (Facebook Ads, Instagram Ads, Google Ads, TikTok Ads)
- Inbox data
See all available endpoints here:
👉 Metricool API documentation
How to use Metricool in Power BI
- Open Power BI Desktop
Go to Get Data > Web and select the Advanced option.
- Enter the endpoint URL you want to query
Example to get your connected accounts: https://api.metricool.com/v1/accounts
- Add your authentication token
In the header section, add:
- Key:
Authorization
- Value:
Bearer YOUR_TOKEN
👉 Check section 3 of the official Microsoft documentation to learn how to add HTTP header parameters like Authorization: Bearer YOUR_TOKEN
.
- Create your custom queries
Use Power Query to shape the data: group by date, filter metrics, combine with other sources, etc.
- Build your visualizations
Once you have the data, you can create charts, tables, and dashboards to analyze your content and campaign performance in one place.
Keep in mind
- This type of connection requires technical knowledge and API experience.
- If you’re unsure how to use a specific endpoint, refer to the documentation or contact our team.
Updated on: 04/07/2025
Thank you!