My finance events look stale in Power BI

You're querying FINANCE.FINANCE_EVENTS from Power BI and the data appears frozen. Recent transactions (FBA fees, refunds, settlement events) aren't showing up even though they should. In most cases this is a query problem inside Power BI, not a refresh issue on DataHawk's side.

What I can observe

• A Power BI report against FINANCE.FINANCE_EVENTS shows no rows past a certain date
• The "stuck" date can be days or weeks old
• The DataHawk app's finance dashboard shows fresh data for the same workspace
• A specific row type (for example Order-ItemFee-FBAPerUnitFulfillmentFee in the DESCRIPTION column) has no recent entries
• Other tables in the same database refresh normally

Why is this happening?

The most common cause is filtering on SYNC_TIME in the Power BI query. SYNC_TIME is a technical column that records when DataHawk loaded a specific row into the warehouse; NOT when the financial event happened. If your incremental-refresh policy uses SYNC_TIME as the time boundary, rows whose event dates fall before that boundary appear missing, even though they're present in the table.

The correct field for business-meaningful filtering is POSTED_TIME (or POSTED_DATE for date-only filtering): the time Amazon posted the event. That's also what drives the visible "last updated" date on DataHawk dashboards.

What can I do?

Table.SelectRows(Source, each [SYNC_TIME] >= RangeStart and [SYNC_TIME] < RangeEnd)

Table.SelectRows(Source, each [POSTED_TIME] >= RangeStart and [POSTED_TIME] < RangeEnd)

SELECT posted_date, SUM(amount_usd)
FROM finance.finance_profit_ledger
WHERE workspace_id = <your WSID>
  AND event_signature ILIKE '%Financial Events | Order | Item Fee | FBA Per Unit Fulfillment Fee%'
  AND posted_date > CURRENT_DATE() - 30
GROUP BY ALL;

Recommendation: prefer FINANCE_PROFIT_LEDGER over FINANCE_EVENTS

For most finance reporting, FINANCE.FINANCE_PROFIT_LEDGER is the recommended table. It's a profit-oriented version of FINANCE_EVENTS with cleaner attribution, deduplication already applied, and consistent semantics across event types. The same view DataHawk's own finance dashboards use.

If your Power BI report was built on FINANCE_EVENTS directly, consider migrating to FINANCE_PROFIT_LEDGER. See Amazon Seller Profit Data for the side-by-side and how the two tables relate.

Still not working?

If you've confirmed all three of:

• Power BI has refreshed recently
• Your query filters on POSTED_TIME, not SYNC_TIME
• The direct warehouse query returns no recent rows for the affected event signature

…then it's a real sync issue. Email [email protected] with:

• Your WSID
• The exact DESCRIPTION value or event_signature you're missing
• The date range you expected data for
• A screenshot of the warehouse query result showing zero recent rows

Related articles

• Amazon Seller Profit Data: When to use finance_profit_ledger vs finance_events
• My advertising data is not populating
• I don't see traffic data for my ASIN