Data count is mismatching between UI and query the dataset | Community
Skip to main content
September 4, 2025
Solved

Data count is mismatching between UI and query the dataset

  • September 4, 2025
  • 1 reply
  • 248 views

Hi

I query the dataset select count(*) from __dataset 

and in UI data count is not matching 

 

what could be the reasons

 

 

Best answer by Devyendar

When you say UI, is it Profile UI or Dataset UI? The Dataset UI shows data for only last 7 days or Last 30 days but the query will output the entire data loaded into the dataset since the beginning of the flow.

1 reply

Devyendar
DevyendarAccepted solution
Level 6
September 4, 2025

When you say UI, is it Profile UI or Dataset UI? The Dataset UI shows data for only last 7 days or Last 30 days but the query will output the entire data loaded into the dataset since the beginning of the flow.

AEP_guyAuthor
September 4, 2025

It’s dataset UI

AND i query the dataset using batch id