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

The steps in this article are intended as a general guide and may vary depending on updates to each platform. We recommend checking the official documentation of the tool you’re using to ensure you follow the most up-to-date process.

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

Was this article helpful?

Thank you!