Couldn't load the data for this visual- Direct Query

[sharmisaranga09]

Hello Team,
     I have been facing Data load issue with table visuals as well as slicer visual. Sometimes the data loads perfectly and sometimes I am getting this error. Is there a way to limit the data and ;load only when the scroll bar is moved for Table visual. As for slicer I am just getting one of the column from a Datasource table and using it as a dropdown filter for the table visual.

[Anonymous]

Hi @sharmisaranga09 ,

Just try the steps I have pasted in the Filter Pane and you may be able to see the results you wanted.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sharmisaranga09]

This would only show top n values if I want to just see all the data in a table what should I do? Can I have something like pages for a table, where I can move next pages to see next set of data?