Power BI Report View Table Row Limitation?

[mgcchkn]

I have a spreadsheet that I'm importing into Power BI and when I'm looking at the Table View, it shows all 49,723 rows.  But in Report View using a Table visual it's only showing me 337 rows.  Same result on the webservice when I publish the report.

Any idea how I can get all of the rows to show up in Desktop and Service?

[parry2k]

@mgcchkn I think you should share some sample data and how you are visualizing it. There can be many factors and don't want to mislead. 

[mgcchkn]

so that's basically what the data looks like, but the Grizzly Bear part changes and each of those have YTD data.  Using the table visual.

[vicky_]

There's two things that might be happening:

• by default, only the top ~500-ish rows (i'm not sure of the exact number) are being loaded until you scroll to the bottom. Then it will load in the next chunk of rows. I don't think there's a way to control this.
• otherwise, you might be aggregating some rows - this will usually happen with number type fields. You can right click on the field and select "Do not summarize" if this is the case

[parry2k]

@mgcchkn if the columns you are using on the table visual are not unique, it will group all these rows together. Maybe add an index column (unique column in PQ) and add this new column in the table visual and then you will get the correct number of rows. Basically, each row needs to be unique.

[mgcchkn]

I have about 147 different widgets and each one of them has data from 1/1/23 to 12/3/23.  It's only showing me 1 widget's YTD data.  You think an index column would fix that?