I'm developing a custom dynamic chart for Power BI, where my model selects the fields, aggregation, and filtering in real-time. The problem I’m facing is that Power BI limits the data passed to the custom visual to the first 1,000 rows, which makes it difficult to perform aggregations over a larger dataset (e.g., 100K rows).

For example, I want to show the overall count of rows, but I don’t want the aggregation to be based on just the first 1K or even 30K rows. Instead, I need the aggregation to be performed on all the data, but I still want to present only the aggregated result.

I understand that there is no way to directly include DAX in my custom visualization, and I came across this thread where similar issues are discussed, but I’m still unclear about how to approach this.

What are the best ways to handle data aggregation in Power BI when working within the 1,000-row limit? I’d prefer to perform the aggregation before the data is passed into my custom visual if possible. Any suggestions?