---
title: "How to use data blending in your data destination"
slug: "how-to-use-data-blending-in-your-data-destination"
description: "Learn how to use data blending in Google Sheets, Looker Studio, Excel, Power BI, and more with our step-by-step guide for effective data management."
updated: 2026-05-06T11:28:28Z
published: 2026-05-06T13:30:20Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# How to use data blending in your data destination

Follow these instructions to use data blends in Google Sheets, Data Studio, Excel, Power BI, and Query Manager (the Supermetrics API). We have a separate article for [using blends in data warehouse transfers](/v1/docs/how-to-use-data-blending-in-data-warehouse-and-data-lake-transfers).

[Learn more about how the data blending feature works](/v1/docs/about-data-blending).

If you're interested in the data blending feature, [contact us](https://supermetrics.com/enterprise-contact).

## Before you begin

You need to create your data blends on the Supermetrics Hub before they can be used in destinations. [Follow these instructions to create your blend](/v1/docs/how-to-create-and-manage-data-blends)!

If you have already created your data blend on the Hub, follow the instructions below to start using the blend in your data destination.

## Instructions

****Google Sheets****

1. Navigate to **Extensions → Supermetrics → Launch sidebar** to open the Supermetrics sidebar.
2. Click **Create new query**.
3. Under **Data source**, select **Data Blending**.
4. Select a connection.
5. Under **Available blends**, select a data blend.
6. Select metrics and dimensions.
7. Click **Get data**.

****Data Studio****

> [!NOTE]
> Note
> 
> When using data blending in Data Studio, you need to first connect to Data blending to Data Studio from the Supermetrics Hub. Otherwise, the Data blending data source doesn’t show up in Data Studio.
> 
> After connecting, you can find the Data blending data source on Data Studio.

Follow these steps to connect Data blending to Data Studio:

1. On the [Supermetrics Hub](https://hub.supermetrics.com), go to **Data blending** under **Manage**.
2. Click **Use your blends in destinations**.
3. In the popup, click **Go to connector** to connect the Data blending data source to Data Studio.
4. In Data Studio, select a Supermetrics team and click **Next**.
5. Select a data blend, and click **Connect**.
6. Click **Create report**, and then **Add to report**.
7. Select metrics and dimensions.

After connecting Data blending to Data Studio, you can find the Data blending data source the same way as other data sources:

1. In Data Studio, click **Add data**.
2. Select the **Data Blending** data source by Supermetrics.
3. Select a team, and click **Next**.
4. Select a data blend.
5. In the pane's top right, click **Connect**.
6. Click **Create report**.
7. Click **Add to report**.
8. Select metrics and dimensions.

****Excel****

1. Click **Data → Show Supermetrics** to open the sidebar.
2. Under **Data source**, select **Data blending**.
3. Select a connection.
4. Under **Available blends**, select a data blend.
5. Select metrics and dimensions.
6. Click **Get data**.

****Power BI****

In Power BI, the Data Blending data source is available through the old Query Manager.

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **Power BI** under **Analyze**.
2. Click **Manage queries in the old query manager**.
3. Select **Data Blending** as the data source.
4. Select a connection.
5. Under **Available blends**, select a data blend.
6. Select metrics and dimensions.
7. Click **Run query**.
8. To make the query available for Power BI, click **Save query**.

****Query Manager (API)****

1. On the [Supermetrics Hub](https://hub.supermetrics.com/), go to **API queries** under **Manage**.
2. Select **Data Blending** as the data source.
3. Select a connection.
4. Under **Available blends**, select a data blend.
5. Select metrics and dimensions.
6. Click **Run**.

****Data warehouse and data lake****

Take a look at our article on [how to use data blending in data warehouse and data lake transfers](/v1/docs/how-to-use-data-blending-in-data-warehouse-and-data-lake-transfers).