Error in Report
SQL error: Exporting report ‘[report name]’, Incorrect string value
When you see the error message "SQL error: Exporting report '[report name]', Incorrect string value" in your PMA Hub under Exports > SQL > View Logs, it indicates that your MySQL server is unable to process certain characters in your data. Error "SQL ...
Invalid Field Name Error: The data source associated with this component has invalid characters in its field names
When using Looker Studio with Power My Analytics connectors, you may encounter an error about invalid characters in field names. This article explains what causes this issue and how to resolve it with our support team. Error "Invalid field name ...
Error: Exporting report '[report name]', the owner of the report has left the organization. Please assign a new owner.
This article explains what to do when you encounter an error message indicating that a report owner has left your organization when attempting to export to BigQuery. Error Message Error: Exporting report '[report name]', the owner of the report has ...
Google Ads Error: Invalid Combination of Metrics and Dimensions Report Configuration Issue
When working with Power My Analytics' Google Ads connector for Looker Studio, you may encounter an error stating "Invalid Combination of Metrics and Dimensions Report Configuration Issue". This guide will help you understand the cause of this error ...
Google Sheets Error: "Exception: Service Timed Out: Spreadsheets" or "Service Spreadsheets timed out when accessing document"
When using the Power My Analytics spreadsheets add-on in Google Sheets, you may encounter a timeout error that prevents your reports from refreshing. This guide will help you understand the cause of this error and provide a straightforward solution ...
Apps Script Error: This Report is Over 50MB of Compressed Data
Error You may receive the following error message in your Looker Studio or Google Sheets report: "Apps Script error: This report is over 50MB of compressed data. Please reduce the date range and/or fields in this report." Cause Power My Analytics' ...
Google Sheets Error: Query Inactivity Error
If you are receiving a Query Inactivity Error when using our Sheets add-on, the following steps may help to resolve the issue. This page will assist you with the following error in Google Sheets: Query Inactivity Error Solution First, duplicate the ...
Instagram Insights Error: "Unable to Get Live Data for This Component" When Using Engagement or Post Engagement Rate
This article will help to resolve the following problem: In Looker Studio, an Instagram Insights report using the Engagement or Post Engagement Rate fields may display the error: "Unable to get live data for this component. Please try again in a few ...
Spreadsheets Error: Exceeded Maximum Execution Time
This article will assist you with the following error: Exceeded maximum execution time Cause When using the spreadsheets add-on for Google Sheets or Excel, the add-on may time out with this error when you have a large number of reports in your ...
Error: "You have no "tweets" to report on" or "This ads account does not have access to tweets"
This article will assist you with the following errors: You have no "tweets" to report on. Please check your Twitter Analytics account to make sure you still have access. This ads account does not have access to tweets Cause You need to set up an X ...
BigQuery Export Limitations
Your data exports to BigQuery may encounter errors in certain situations such as large export sizes. This article will show you how to identify and correct errors with your BigQuery exports. Export Limitations If you are using connectors other than ...
Community Connector Error: Current Combination of Data Breakdown Columns Is Invalid
When using your Facebook Ads reports in Looker Studio, you may receive a connector error from trying to combine two or more dimensions that Facebook's API cannot combine. This article will show you how to identify and fix the error. This article will ...
Community Connector Error: Authorization Error - (#10) Application Does Not Have Permission for This Action
This article will address the following error: Authorization Error - (#10) Application does not have permission for this action. Cause The Instagram Insights account in use does not have the appropriate permissions to connect via Power My Analytics. ...
How to Avoid Duplicate Reports in Looker Studio
After making a copy of a report, you may notice that changes made to the copy reflect on the original. This article will show you how this happens and how to fix it. What Is a Duplicate Report? When a copy is made, selecting from available data ...
Troubleshooting Calculated Fields in Looker Studio
This article will assist with calculated fields that are displaying incorrect results. Check Parentheses The most common cause of calculated field errors is missing parentheses. Type SUM(fieldname) around each field to obtain correct results.
Missing Campaigns in Google Ads
This article will address the following issue: Performance Max (now called Discovery) campaigns do not appear in report. Cause Performance Max/Discovery campaigns can only be reported at the Campaign level. Solution Ad group or Ad level reports will ...
Facebook Error: Selected Metric Can Only Be Requested in 1/7/28 Day Periods
This article will address the following error: Unique metrics can only be requested in 1/7/28 day ranges. Cause Fields in Facebook Insights that count individual users are categorized as "unique." These metrics can only be summed accurately in 1 day, ...
PMA Error: Selected Dimensions Can Only Be Requested with URL Impression
This article will address the following error: PMA Error: Selected dimensions can only be requested with URL impression as report settings table. Cause Page and Search Appearance dimensions can only be retrieved while the Tables are set to URL ...
No Data on Amazon Seller Report That Previously Worked
This article will address the following error: Reports that previously worked now display No Data. An error is displayed in the logs for your data source: "Task Failed Error: Authorization Error - PMA Error - Please ensure you have the minimum ...
Unable to Schedule Refresh in Google Sheets
This article will address the following error: Unable to schedule refresh in Google Sheets. Error shown is "Exception: Bad Value." Cause Google Sheets requires you to set a Time Zone. Additionally, you must be a member of the report's hub in order to ...
Past Two Days of Data Missing on Instagram Insights
This article will address the following issue: Instagram Insights data is missing for the previous 48 hours. Cause Instagram Insights reports data for all fields with a delay of 48 hours. This is a limitation of Meta’s API for Instagram Insights and ...
Basic Troubleshooting
Most errors can be solved easily and independently. This article will guide you through some basic troubleshooting steps to get your reports looking great as quickly as possible. Click "See Details" on the Error Description If your report was made ...
Error: Instagram Account Is Not Connected to a Facebook Page
This article will address the following issue: You repeatedly receive this error in your report even though the account is verifiably connected to Facebook. This Instagram account is not connected to a Facebook Page. See the following article for how ...
Custom or Calculated Fields Show the Wrong Numbers
This article will address the following issue: Custom fields in a Data Studio report return inaccurate calculations. Solution Type SUM () around each of the fields in your formula.
How to Share Edit Access to Your Reports
Giving edit access to support@powermyanalytics.com is the best way to expedite ticket resolution. This article will show you how to provide all of the needed permissions from each reporting tool. Why We Ask For Edit Access to Your Report Power My ...
Time Zones Do Not Align with Walmart Seller Center
This article will assist with the following error: Time zones in report do not match time zones in Walmart Seller Center. Cause Power My Analytics is missing Shipping permissions from Walmart. Solution Log into your Walmart Developer Portal and find ...
How to Create Working Age and Gender Charts
Many of our clients have difficulty creating age and gender charts in their reports. This article will tell you everything you need to know to create a functioning age or gender table with most connectors. Match [collection] fields Most demographic ...
What to Do When a Report Is Loading Slowly
We understand how frustrating it is when you take time to build a report and it is loading very slowly or timing out. This article will help you with some troubleshooting steps you can use to get your reports loading quickly again. Looker Studio Use ...
Restrictions for Off-Facebook Action Metrics
Facebook's updates following the iOS14 release have changed the metrics they are able to collect. There is now a lot less demographic information to use in reports. This article will help you understand the changes to breakdown reports. This article ...
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 ...
Results Field Does Not Work
This article will address the following issue. Results field shows zeroes. This may occur in Facebook or Instagram's Ads connector. Cause Facebook does not allow aggregation of data across attribution windows. The Results metric will also not include ...
Facebook and Instagram Insights Time Zone Mismatch
This article will address the following issue: The time in a Facebook or Instagram Insights report does not match the time shown in Facebook Creator Studio. Cause Facebook and Instagram's APIs format all of their data to match the time zone at their ...
Google Sheets Error: "Error: Sheet does not exist:"
This article will assist you with the following error: "Error: Sheet does not exist:" Cause You have renamed a sheet after creating a report. You will need to update the PMA Configuration page and refresh the report list. Solution Go to the PMA ...
Choosing the Right Metrics for Website Actions and Pixels Performance Reporting
Learn how to find the right fields in Looker Studio to correctly report on Facebook Ads metrics including dealing with misaligned data. Accurately reporting your metrics will help you track leads, conversions, revenue, and Facebook Ads ROI. Because ...
A Facebook Ads Account Is Missing From The List When Trying To Create A Report
This article will help you to resolve the following problem: One or more Facebook accounts are missing from the list when trying to create a report. Cause When you connect to Facebook in the Hub, only accounts that are already added to your Business ...
Connector Error: Can’t Mix and Match Fields from Different Tables
This article will help you to solve the following 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: This action is not supported while logged into multiple accounts in the same domain or multiple consumer accounts. Please log out and try again.
This article will assist you with the following error: "Error: This action is not supported while logged into multiple accounts in the same domain or multiple consumer accounts. Please log out and try again." Cause Connecting to Looker Studio ...
Looker Studio Error Troubleshooting Guide
Getting an error in Looker Studio? Click on the wrench icon or "See details" link to find the error details. Common Errors Error: You must select a valid config when connecting to the data-source Error: This action is not supported while logged into ...