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.