- Open the following file in a text editor: C:\Program Files\pentaho\server\biserver-ee\pentaho-solutions\system\data-access\settings.xml
- Change the default value that is located in the following tag to the desired sampling amount:
data-access-csv-sample-rows>10000/data-access-csv-sample-rows>(in this tag I have increased it to 10000)
- Restart your BI Server
This will help ensure that you have a success production of your prototype so that you can show your end users how easy Pentaho is to use to slice and dice their data, build reports and dashboards.