This issue could be related to Mixpanel's query result caching behavior. When you make API calls to Mixpanel's Insights, the results are cached on Mixpanel's servers for varying periods depending on the date range of your query:
- Queries with date ranges under 1 day are cached for up to 1 hour
- Queries with date ranges under 1 week are cached for up to 12 hours
- Queries with date ranges under 1 month are cached for up to 1 day
- Longer date ranges have progressively longer cache periods (up to 14 days for queries spanning 1 year or more)
Mixpanel Documentation explains this caching behavior in detail.
Even though PowerBI successfully refreshed the connection, it might be retrieving the same cached data from Mixpanel's servers. To get the most current data, you would need to refresh the cache on Mixpanel's side first.
In the Mixpanel UI, you can refresh the query results cache by:
1. Navigating to the report
2. Clicking the three dots overflow menu
3. Selecting "Refresh Data"
If you're working directly with the API, you might need to wait until the cache expires based on your query's date range before seeing updated data.
Additionally, check if there might be data discrepancies due to:
- Different timezones between systems
- Late data ingestion (Mixpanel has a policy for latency on exported events of 24 hours end-to-end)
- Data sync issues
Mixpanel Documentation provides more information on troubleshooting data discrepancies.
