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"

"Invalid configuration: Invalid combination of metrics and dimensions"

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.

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.

Solution

In your Hub, click Schema Explorer under Tools in the left navigation pane.

Select the connector you would like to use
Choose the fields you'd like to include.
We will remove incompatible fields from the list and display the number of fields that remain.