Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi everybody,
The limit of data points in power bi is 3500, someone know one alternative for work with scenario?
Tks
Hi @Twister8,
What do you mean the "limit of data points in power bi is 3500"? The limitation for the Data Model size is 250MB. See: The Conceptual Data Model and Limits. Sometimes, many visuals can't display large amount of data, then we need to add some filters.
Best Regards,
Qiuyun Yu
Tks for answer...
I need alternative for work with this limitation, more details in this post
https://community.powerbi.com/t5/Desktop/Map-plotting-limit-3-500/m-p/95440#M40224
Do I have any alternative?
Hi @Twister8,
As far as I know, there is no alternative to display more than 3500 data points in the map visual. For your requirement, please vote on this similar thread: Allow more data points to be displayed on a map.
Best Regards,
Qiuyun Yu
there is a way,
Building a custom visual will allow you to set any number as a limit.
The solution to this problem is to specify a count of values that you want to show in your Visual.
this is possible by going into the capabilities and setting the 'count' property of the datareduction algorithm to whatever you want. We tried this with 100.000 and it worked fine, albeit a tad slower than usual.
It will affect performance, but otherwise it will work.
Hi. Did you check the length of your array? I've tried matrix, table and categorical. No matter what it is capped at 30000 points.
What does you capabilities.json look like?
Thanks
Here is a blog that touches on exactly the question you raise.
I hope it helps
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |