This article will help to resolve the following problem: when pulling data from the Amazon Seller Central Sales and Traffic by ASIN report into Data Studio, Data Builder, Google Sheets, Microsoft Excel, or any other Power My Analytics reporting destination, you may see the error: "We were unable to get live data for this component. Please try again in a few minutes."
The error appears in Data Studio as a Community Connector Error dialog, and in Data Builder preview data as a red banner reading "Code: 500; Message: We were unable to get live data for this component. Please try again in a few minutes."
Cause
On April 24, 2026, Amazon changed how it applies API rate limits to the Sales and Traffic business report (the underlying source for the Sales and Traffic by ASIN report). The rate limit is now enforced at the seller account level (1 request per 15 minutes per seller account) instead of separately per marketplace ID.
The Power My Analytics Sales and Traffic by ASIN report is a live report: data is fetched directly from Amazon at the moment your report renders, with no Power My Analytics-side cache and no manual backfill option. When a seller account has multiple marketplace IDs connected, each report render fans out into multiple Amazon SP-API calls that now share a single rate-limit bucket. Some calls succeed and others get throttled, which Power My Analytics surfaces as the "unable to get live data for this component" error.
Manual backfilling does not resolve this error, because the Sales and Traffic by ASIN report does not store data on Power My Analytics' side; every render goes back to Amazon live.
Solution
Use the Sales and Traffic by Child ASIN report in place of the Sales and Traffic by ASIN report. The Sales and Traffic by Child ASIN report is cached on Power My Analytics' side (not live-fetched on each render), so it is not affected by Amazon's account-level rate limit. Fields available in the Sales and Traffic by ASIN report have direct equivalents in the Sales and Traffic by Child ASIN report; for example, Unit Session Percentage is available in both.
To switch your report:
- In your reporting destination (Data Studio, Data Builder, Google Sheets, Microsoft Excel, or other), open the data source or query that uses the Sales and Traffic by ASIN table.
- Replace the Sales and Traffic by ASIN table with the Sales and Traffic by Child ASIN table.
- Update any field references to use their Sales and Traffic by Child ASIN equivalents. (You can use the Power My Analytics Schema Explorer to confirm field names.)
- Refresh your report.
If you need help identifying field equivalents or making the switch, our support team is happy to assist. Please
submit a ticket.