Alternative to data points more that 3500

Question

Hi everybody,&nbsp;The limit of data points in power bi is 3500, someone know one alternative for work with scenario?&nbsp;Tks

phil_seamark · Answer

Here is a blog that touches on exactly the question you raise.&nbsp;I hope it helps&nbsp;http://angryanalyticsblog.azurewebsites.net/index.php/2016/08/02/map-visual-how-to-deal-with-large-datasets/

v-qiuyu-msft · Answer

Hi Twister8,
&nbsp;
What do you mean the "limit of data points in power bi is 3500"? The limitation for the Data Model size is&nbsp;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.
&nbsp;
Best Regards,Qiuyun Yu

twister8 · Answer

HI&nbsp;v-qiuyu-msft&nbsp;Tks for answer...&nbsp;I need alternative for work with this limitation, more details in this post&nbsp;https://community.powerbi.com/t5/Desktop/Map-plotting-limit-3-500/m-p/95440#M40224&nbsp;Do I have any alternative?

v-qiuyu-msft · Answer

Hi Twister8,
&nbsp;
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&nbsp;similar thread: Allow more data points to be displayed on a map.
&nbsp;
Best Regards,Qiuyun Yu

lizardous · Answer

there is a way,&nbsp;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.

Forum Discussion

Alternative to data points more that 3500

6 Replies

Related content

Alternative to SWITCH ()?

New and Need Help - Alternating Rows

Smooth run of data points

alternative chart power bi

Alternatives to QuickBooks connector post deprecation