admin管理员组文章数量:1395890
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?
本文标签:
版权声明:本文标题:powerbi - How to Perform Aggregation in Power BI Custom Visuals While Handling the 1,000 Row Limit? - Stack Overflow 内容由网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:http://www.betaflare.com/web/1744088390a2588963.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论