cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Twister8 Regular Visitor
Regular Visitor

Alternative to data points more that 3500

Hi everybody,

 

The limit of data points in power bi is 3500, someone know one alternative for work with scenario?

 

Tks

6 REPLIES 6
Moderator v-qiuyu-msft
Moderator

Re: Alternative to data points more that 3500

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Twister8 Regular Visitor
Regular Visitor

Re: Alternative to data points more that 3500

HI @v-qiuyu-msft

 

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?

Moderator v-qiuyu-msft
Moderator

Re: Alternative to data points more that 3500

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Lizardous Frequent Visitor
Frequent Visitor

Re: Alternative to data points more that 3500

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.

mclasson Frequent Visitor
Frequent Visitor

Re: Alternative to data points more that 3500

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

Phil_Seamark Super Contributor
Super Contributor

Re: Alternative to data points more that 3500

Here is a blog that touches on exactly the question you raise.

 

I hope it helps

 

http://angryanalyticsblog.azurewebsites.net/index.php/2016/08/02/map-visual-how-to-deal-with-large-d...


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!