When retrieving data from Adobe Analytics into Power BI, sometimes only 580 records are fetched, while occasionally it shows 1000. This falls short of the expected total, which is approximately 50,000 records. I'm unsure why this inconsistency keeps occurring.

I'm having trouble with the order counts not matching up in real time. When I checked the order counts from an hour or two ago, they didn't match the data in our backend. Also, if I compare the orders from today to those from a couple of days later, the count increases. How can I be sure that the ho...