# Show all Data in saved Search on a Kibana Dashboard **URL:** \ **Category:** Kibana\ **Created:** [May 13, 2020, 9:31am UTC](https://discuss.elastic.co/t/show-all-data-in-saved-search-on-a-kibana-dashboard/232402 "2020-05-13T09:31:50Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![KoettingSimon](https://avatars.discourse-cdn.com/v4/letter/k/ba9def/32.png) [@KoettingSimon](https://discuss.elastic.co/u/KoettingSimon)\ **Post date:** [May 13, 2020, 9:31am UTC](https://discuss.elastic.co/t/show-all-data-in-saved-search-on-a-kibana-dashboard/232402/1 "2020-05-13T09:31:50Z")
Hi All, Im using Kibana 7.6.1. I need to greate a monthly report of some Audit-Data. I would like to greate a Dashboard with some visualisations and a saved search showing all "raw" Audit-Data. Then i would use watcher to generate monthly a PDF of the Dashboard and archive the PDF (3rd Party Software). My Problem is, i couldn't find a way to display all data in a saved search on the Dashbaord. Its limited to 50 Events. I found some older Topics discussing the same, with no solution. Is this now possible? My only idea would be to export the search seperatly as CSV and store this beside the PDF. Are there any other ways to do this? Regards, Simon ---
**Author:** ![cheiligers](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cheiligers/32/73114_2.png) [@cheiligers](https://discuss.elastic.co/u/cheiligers)\ **Post date:** [June 4, 2020, 9:51pm UTC](https://discuss.elastic.co/t/show-all-data-in-saved-search-on-a-kibana-dashboard/232402/2 "2020-06-04T21:51:29Z")
@KoettingSimon I'm not sure I understand what you mean by 'display all data in a saved search on the Dashboard' and it being limited to 50 Events. Do you mean that the pagination is set to 50? If so, there's a `discover:sampleSize` setting in Management / Advanced Settings that is adjustable. ---
**Author:** ![KoettingSimon](https://avatars.discourse-cdn.com/v4/letter/k/ba9def/32.png) [@KoettingSimon](https://discuss.elastic.co/u/KoettingSimon)\ **Post date:** [June 5, 2020, 5:08am UTC](https://discuss.elastic.co/t/show-all-data-in-saved-search-on-a-kibana-dashboard/232402/3 "2020-06-05T05:08:25Z")
Hi @cheiligers, Thanks for your reply. > [@cheiligers](#): > > Do you mean that the pagination is set to 50? Yes, that's basically what i mean. > [@cheiligers](#): > > there's a `discover:sampleSize` setting in Management / Advanced Settings that is adjustable. I also found this setting, but nothing changes. I set the discover:sampleSize to 100, later to 500 but all saved searches in a dashboard still have pagination set to 50. ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/6/a680a329f43056e0141ec457d3fd7c189838c324.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/c/6/c660417505a39902018c90b7af3a649ad7ba6902.png) ---
**Author:** ![cheiligers](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cheiligers/32/73114_2.png) [@cheiligers](https://discuss.elastic.co/u/cheiligers)\ **Post date:** [June 5, 2020, 3:14pm UTC](https://discuss.elastic.co/t/show-all-data-in-saved-search-on-a-kibana-dashboard/232402/4 "2020-06-05T15:14:51Z")
I tested this too and see what you mean. For now, I guess downloading the csv is your best option. I've searched in the open Github issues but couldn't find an issue for this. There are, however, plans to migrate the Discover table and Discover saved search to use the EUIDataGrid component but there's no specific target date. ---
**Author:** ![KoettingSimon](https://avatars.discourse-cdn.com/v4/letter/k/ba9def/32.png) [@KoettingSimon](https://discuss.elastic.co/u/KoettingSimon)\ **Post date:** [June 5, 2020, 3:34pm UTC](https://discuss.elastic.co/t/show-all-data-in-saved-search-on-a-kibana-dashboard/232402/5 "2020-06-05T15:34:13Z")
Thanks for your help. So I will start with the csv option and open a issue on GitHub for this. Hopefully we can then use it in a later release. ---
**Author:** ![cheiligers](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cheiligers/32/73114_2.png) [@cheiligers](https://discuss.elastic.co/u/cheiligers)\ **Post date:** [June 5, 2020, 4:17pm UTC](https://discuss.elastic.co/t/show-all-data-in-saved-search-on-a-kibana-dashboard/232402/6 "2020-06-05T16:17:05Z")
Thank you for opening an issue! If you wouldn't mind posting a link to the issue here, it'll help others if they need to do something similar. 🙂 ---
**Author:** ![KoettingSimon](https://avatars.discourse-cdn.com/v4/letter/k/ba9def/32.png) [@KoettingSimon](https://discuss.elastic.co/u/KoettingSimon)\ **Post date:** [June 5, 2020, 4:53pm UTC](https://discuss.elastic.co/t/show-all-data-in-saved-search-on-a-kibana-dashboard/232402/7 "2020-06-05T16:53:53Z")
> [@cheiligers](#): > > If you wouldn't mind posting a link to the issue here, it'll help others if they need to do something similar. Of course. Here is the link to the issue: > > > At the moment, if you add a saved search on a Dashboard its pagination its set t…o 50 and you cant change this. > Thats fine for a Dashboard in a "traditional use" but if you want to have e.g weekly or monthly PDF Reports and have more than 50 entries in the saved search you doesn't have all entries in the PDF. > In such a use case its common to automate the generation and then you may didn't recognize if there are more than 50 events in the reporting time span. > If you think about a long-time archive for years, this could be critical if you delete the raw data after a while and keep only the PDF for a long time. > > A way to implement this may would be to do it like the existing \[discover:sampleSize\](https://www.elastic.co/guide/en/kibana/current/advanced-options.html) setting. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 3, 2020, 4:54pm UTC](https://discuss.elastic.co/t/show-all-data-in-saved-search-on-a-kibana-dashboard/232402/8 "2020-07-03T16:54:10Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.