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!!

  • LetBloodline's avatar
    LetBloodline
    Advocate I
    10 years ago

    It's a chore but it happens even if you have some data too small to be rendered

     

    dato1quantità
    a1000000
    b900000000
    c1

     

    Try put that on a pie and the yellow signal appears. But "too many values" is a misleading information. And i can be OK with not be able to see c's slice. I'd really like to be able to remove that warning

  • 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.