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.
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.
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
- 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.
Still having issues?
Send us a ticket and we will get back to you.
Related Articles
Community Connector Error: Invalid Combination with a Collection
This article will help to resolve the following community connector errors. Cause This error occurs when two incompatible fields are placed in the same table together. In this example, Total People Who Viewed By Country could not be combined with ...How to Use Schema Explorer
The PMA Schema Explorer is an easy way to find metrics and dimensions that are available for your connectors and identify any possible conflicts or errors. Schema Explorer can find additional fields that are compatible with your selected fields and ...Community Connector Error: Service Invoked Too Many Times for One Day: urlfetch
When working with Looker Studio reports in Power My Analytics, you may encounter an error that prevents your data from loading. This guide will help you understand the cause of this error and provide solutions to resolve it, ensuring you can continue ...Community Connector Error: This Instagram Account Is Not Connected to a Facebook Page
This article will help to resolve the following issue: Community Connector Error PMA Error: This Instagram Account Is Not Connected to a Facebook Page Cause Usually, the Instagram account has not yet been connected to a Facebook Page. Sometimes, it ...Community Connector Error: There Was an Error Caused by This Connector
This article will assist you with the following error: Community Connector Error: "There was an error caused by this connector." Cause This is a Google error caused by too many charts or other complex calculations in a Looker Studio report. This can ...