Forum Discussion

mstefancik's avatar
mstefancik
Advocate IV
11 years ago

Too many values

Hi, I am building simple column chart which represents sold items by stores. We have 171 stores. I supposed to get 171 columns to see sales of every single store. After creation there is yellow tria...
Need Help
getthedata's avatar
getthedata
New Member
10 years ago

Bump bump

 

Hello Power BI team, can I get some clarification what this message really means?

 

Some people report that it is only an issue on the desktop tool and uploading report to PowerBI site resolves. However, that doesn't work for me.

 

Others as in this thread above suggest data should be transformed into groups in order for PowerBI to be able to present it.  Frankly this is not something that I expect is a requirement.  I experience the "Too many values" message with record sets that are not what would be considered "too big" on any other BI solution including Excel pivot tables, Power Pivot, etc.

 

I am using latest PowerBI desktop tool and a license free PowerBI with my Office365 E3 account.

 

What is really happening here?

 

* is it a Desktop tool limitation?

* is it something that happens in specific situations?

* is it a free PowerBI account limitation?

* is PowerBI just a limited capability BI solution?

* is this something that will be resolved or upgraded in future?

 

 

I really like what i see witih Power BI so far but this is a severe limitation for a modern BI solution.

 

Thanks.

 

Looking forward to your reply!!

WillT's avatar
WillT
Community Admin
10 years ago
Hi everyone. You're running into data point limits that exist to make sure performance isn't impacted. We're aware that there are problems with some sparse datasets, and are working to fix it. We plan to get to a point where you can load charts with many more datapoints, even millions in many cases. Stay tuned for updates in the new year where we'll start to ship improvements to this. Thanks for you patience!
  • RichardL's avatar
    RichardL
    Microsoft Employee
    8 years ago

    WillT wrote on 12-22-2015:  "We're aware that there are problems with some sparse datasets, and are working to fix it."

     

    It is now July 25, 2018, more than three years later, and I'm still running into this "Too many values" limitation.  Please fix it.

  • supeto's avatar
    supeto
    Regular Visitor
    9 years ago

    Any solution to fix this issue in near future? Still have the same problem.

  • supeto's avatar
    supeto
    Regular Visitor
    9 years ago

    Any solution planned in near future? Still have the same problem. Thanks for answer.

  • joaod82's avatar
    joaod82
    New Member
    9 years ago

    Hi, WillT

     

    Is there any advance in that topic? I tried to use the gantt chart today (august-2017) and I am getting the same message (too many values). What I think it's impressive is that my data is not too big... I have something around 25k registries only...

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi,

      I'm falling into this same problem too - and the big, big issue is that the data plotted is incorrect (incomplete). And it is way worse to plot incorrect data than no data at all...

       

      In my case, it is a simple stacked graph. X-axis has about 20 categories, and legend has 85 values. Most of them only apply to one or two categories, and their size varies, so each category has about 4-5 significant legends and a bunch of less important ones. 

       

      The graph renders, with the too many values warning... and renders wrong! What I am adding up is revenue, and quite some revenue is missing - the right-most categories don't show revenues!. That is a definite no-go.... it is increadibly wrong, and only a small warning sign is shown. That's a no-go for mass consumption of the reports....

       

      It really is not important to have a big legends-entry (colors are only useful to differentiate categories, and hovering over them gives the category name, so that's ok). And grouping the categories to have less it not ideal, because it limites the usefulness of drilling down...

       

      Please, PowerBI team, I hope you fix this soon! 

       

      Thanks!