# Connector Error: Can’t Mix and Match Fields from Different Tables

**This article will help you to solve the following Data Studio error:**

**"Community Connector Error: PMA Error | Can't mix and match fields from different tables"**

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/error-can-t-mix-and-match-fields-from-different-tables-for-debugging-purposes-your-subscription-id-is-1.png)

**"Invalid configuration: Invalid combination of metrics and dimensions"**

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/error-can-t-mix-and-match-fields-from-different-tables-for-debugging-purposes-your-subscription-id-is-2.png)

<iframe src="https://www.youtube.com/embed/z6bQ6BdiLo8" width="560" height="315" title="Video" allowfullscreen></iframe>

## Cause

You will receive this error when you have attempted to create a Data Studio chart with two or more fields that do not share a common table. It is important to ensure that all fields in a chart have at least one common table.

> **Note:** **Google Sheets and Microsoft Excel reports** using the Power My Analytics Spreadsheets Addon automatically prevent this error. The addon's field selection interface removes incompatible fields as options when they conflict with currently selected fields, preventing mix-and-match errors from occurring in spreadsheet reports.

> **Important:** **Using Data Builder?** The same field-compatibility limit can appear as the source platform's own API error instead of this message. For example, combining YouTube Analytics video-level fields with channel-level or time-level fields returns YouTube's error "Code: 400; Message: The query is not supported. Check the documentation for a list of supported queries. (badRequest)". See [YouTube Data Builder Error: "The Query Is Not Supported" (400 badRequest)](https://knowledge.powermyanalytics.com/application/troubleshooting/youtube-data-builder-error-the-query-is-not-supported-400-badrequest/) for the YouTube-specific steps.

## Solution

Use Schema Explorer to find fields that share a table:

1. In [your Hub](https://hub.powermyanalytics.com), click **Schema Explorer** under **Tools** in the left navigation pane.
2. Click the **Source** dropdown and select the connector you would like to use.

    ![Schema Explorer with the Source dropdown open](https://knowledge.powermyanalytics.com/application/troubleshooting/images/error-can-t-mix-and-match-fields-from-different-tables-for-debugging-purposes-your-subscription-id-is-3.png)

3. Click the **Filter** button, then **Table**, and check the table you want to report from.

    ![The Table filter in Schema Explorer with one table checked](https://knowledge.powermyanalytics.com/application/troubleshooting/images/error-can-t-mix-and-match-fields-from-different-tables-for-debugging-purposes-your-subscription-id-is-4.png)

4. Build your chart using only the fields that remain in the list. Fields in the same table can always be used together.

To fix a chart that already shows this error, click the **Columns** button in Schema Explorer and turn on the **Table** column. It lists every table each field belongs to, so you can spot the field that doesn't share a table with the rest and replace it.

For more ways to explore fields, see [How to Use Schema Explorer](https://knowledge.powermyanalytics.com/application/tools/how-to-use-schema-explorer/).
