[HELP] - Truncated due to size limits results to no data

[Sofia_2023]

Hello Everyone, 

Good day! 

I would like some help on how to disable this trucated due to size limits. 
I have problem cause when i used filter example country.
the country in filter is not showing the data supposedly on the table because it did only load 36 rows. 

Appreciate your help.
Thank you! 

[Anonymous · Accepted solution]

HI @Sofia_2023,

I don't think you can customize with this part. It shows the preview data to help you clarify the structure of table and it may not need to loading too many records due to performance considering.

If you want to view more records, you can enter to query editor side to check the query table. At this place, power bi will loading more records as preview snap from data source for the next shaping and transform data steps.

Regards,

Xiaoxin Sheng