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

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

This article will help you to solve the following Looker 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 Looker 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.
NotesGoogle 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.



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





    Still having issues?
    Send us a ticket and we will get back to you.