Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
pinky
Regular Visitor

Too many values error in map

Hi, 

I'm building a map report with simple ABC classification of customers. PowerBI is not used for Geocoding, the geolocation data are available in the dataset so it is just drawing these.... However, I now hit the "Too many values" error and apparently not all data are shown.

There are about 3600 customers in total where majority falls into C category... If I only display AB (invstatus 2/3) the error goes away... but it shows up on C category alone (approx 2700 records) and when showin all ofcourse...

 

Is there some way to force all records to be drawn?

Thansk for all ideas!

 

Toomanyerror.png

11 REPLIES 11
Miguel123
Frequent Visitor

Saludos, estoy presentando este problema igual que ustedes, hanm podido solucionarlo?

prasadmom
Regular Visitor

Hello, All, 

We are also facing the same issue.

It could be great to see if Power BI classic Map have overcome the limitation of volume of records which idenifies as bubble or circle. We have 1.24 million Postal codes records to show on map.

We understand that we need to have filter and other dimension but our client want to see all of this dots as a seperate colors based on Individual company (9 in numbers).

 

Please advise.

 

BR

Prasad

asocorro
Skilled Sharer
Skilled Sharer

If you are looking to display where your customers mostly are (and not individual customers), you can try the filled map and use color intensities together with counts.

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro

Unfortunately the inteded result is pinpoint location of the customer with visual representation of the ABC status to serve as tool for field sales to plan their visits in the area... so no, filled map won't do.

I'd rather make this work in Power Bi than code specifically using google/Bing Map api... but seems we hit the roof here Smiley Sad

This is an interesting problem.  What if you didn't get that "too many values" error?  Would the display of all those bunched up little circles help you?  If you zoomed out, there would be circles on top of each other.  If you zoomed in, maybe you would need a gigantic monitor to be able to view them separately.

 

How about two maps?  With one you could zoom the other.  Read about it here: tinyurl.com/pb372qn.

 

map.png

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro

I thought of this solution with a drill down reporrt @asocorro already, unfortunately the data relate to Germany and there is no state / region to use to break it down further. Indeed with high zoom all is drawn on top of each other so it does not give any info, but it's to be used with high zoom for field sales trip planning as mentioned... this is the idea at least. 

The problem is that with zoom change the dataset is not refreshed, so indeed, I do not mind not seeing couple of hundreds points in top zoom where they all just create one big spot.... but when zoomed down they need to be shown. Would it be possible to refresh for data just in the area shown then it is all sorted ofcourse as theer can be around 20 or so points.. but that is not the case unfortunately... I'm probably trying BIMap to do something it has not really been designed for. Should the data be somehow consolidated, theer is no problem, but as it is customer level I'm breaking it on and so many customers.... here we are. Smiley Indifferent

Can't you create another filter in addition to the ABC?  Say, city, customer business type, or salesperson?  You could also resort to a map in R, where you can have more control over the map details.

Connect with me in LinkedIn: https://pr.linkedin.com/in/adolfosocorro
Follow me on Twitter: https://twitter.com/AdolfoSocorro

@pinky - What is the location data, is it city or geocoordinates or something else? Thought would be that you could create a calculated column that essentially consolidated the data in some manner where everything in a certain area all has the same location code for example?


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

@pinky - I haven't ever tried to pin down the exact limits on the visuals and I know of no documentation that specifies the exact limit, the impression that I get is that it is somewhat situational. Also, map visuals are not the only ones that do this so I do not think it is necessarily tied to geocoding. Pie charts and other visuals also exhibit this behavior.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Super User
Super User

@pinky - Unfortunately, I am not aware of any way to superscede the default limits of certain visualizations like maps. I'm sure it is already an Idea, but you could create it if not or vote for it if one already exists.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Yah, but what excatly is the limit @Greg_Deckler? I did not find it anywhere but another thread here where someone experienced this and assumed it is only displaying around 1000 data points. (http://community.powerbi.com/t5/Service/Maps-Number-of-points-limited-at-1000/td-p/7599)

 

I undertsand that when data are to be geocoded on the fly, it needs to be limited somehow, but working with a datasat where geolocation data are already stored, this seem to be unreasonable limitation.

 

No way to force all into the report? Anyone?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.