Magento Business Intelligence Help Center

Why are the results between my database and the SQL editor different?

OTHER FAQS

The majority of the time, differences in results can be attributed to update cycles. If Magento BI is in the process of replicating data from your database to your Data Warehouse, you might see different results even when using the same query.

Connection issues can also result in discrepancies. Navigate to the Connections page (Manage Data > Connections) to check it out - is there an error for the database integration in question? If so, you may need to reauthenticate the integration to get things running again.

If all your integrations are connected successfully and you’re not in the middle of an update cycle, something else may be amiss. Try using our data discrepancy troubleshooting guides to pinpoint the problem.

<< Back to the SQL Report Builder FAQ list

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk