If I understand the requirement correctly, you are trying to use a Data Page (sourced from a Report Definition) in Insights and facing issues with aggregation based on the Allow query setting.
Just to clarify, is your goal to:
-
Use the Data Page purely as a reporting source for Insights? or
-
Apply any additional transformation/filtering on top of the Report Definition?
I tried replicating a similar scenario and observed that when Allow query is unchecked, the Data Page may appear but does not support proper aggregation (like Count), as it behaves more like a UI data source. Handling measures in a response Data Transform might work for display, but it won’t behave correctly in Insights and is not recommended.
When Allow query is enabled, the Data Page is treated as a query able source, and aggregation works based on the underlying Report Definition / Data Object.
In most reporting scenarios, using the Report Definition directly tends to be more reliable unless there’s a specific need for additional processing in the Data Page.