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

1. Open Power BI Desktop
   Go to Get Data > Web and select the Advanced option.

2. Enter the endpoint URL you want to query
   Example to retrieve your connected accounts: https://app.metricool.com/api

3. Add your authentication token
   In the headers section, add:

• Key: Authorization

• Value: YOUR_TOKEN

👉 See section 3 of the official Microsoft documentation for how to add HTTP header parameters like Authorization: YOUR_TOKEN.

1. Build your custom queries
   Use Power Query to transform the data however you need: group by dates, filter metrics, combine with other sources, etc.

⚠️ Make sure your request always includes the parameters blogId and userId.

1. 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.