First 100 Rows Only

[Stewwe1]

Hello Daniel,

I have a quick question:

I can only see the first 100 rows with the preview data function. This was never the case before. Can I set somewhere that I can see all rows again? :-)

Thank you for your help

Stewwe

[Stewwe1]

I found it. There is a setting that sets the 100 row limit for directquery data. But my tables are (almost) all in import mode. If I change the setting there, I can at least see 10,000 records, but I would still like to see all records from import mode tables.

Thanks for the help

[otykier]

Are you using 3.2.3 and does the Table Preview only show the first 100 rows even for imported tables? If so, that might be a regression. We’ll look into it.

[otykier]

So I wasn't able to reproduce this issue. Could you show the types of partitions used on the table where you were only able to view the first 100 records? Thanks!

[Stewwe1]

Hello Daniel,
I have one more hint:

We converted a table to a hybrid table about a week ago. Maybe that is the reason? The limitation to max. 10000 rows definitely affects all of our more than 50 tables in imported mode. Thanks

PS: We´re using 3.2.3

[otykier]

Yes, indeed it seems like hybrid tables are the culprit, however I would expect the issue to only occur on tables that have a DQ partition (so pure DQ tables + hybrid tables would be affected). Could you confirm if the issue also occurs on tables that are pure import (i.e. no DQ partition)? Thanks!

[Stewwe1]

On all of my tables without exception :-\

[otykier]

Hi @Stewwe1
This has been fixed in our latest release. Please note that we're still only able to show the first 100 rows on tables that are hybrid (i.e. have a DirectQuery partition). However, tables that are pure import are now fully viewable.