A report containing FxV metrics is only 20000 rows (75835)

A report in Foglight has been creating which contains metrics from FxV but the report is only returning a maximum of 20000 rows

There is a default limit of 20000 rows on the FxV datasource defined in Foglight. To change this limit please go to

To change the limit go to "Configuration -> Data Sources" (see the attached screenshot) . Select edit for the Foglight Experience Viewer data source instance. Update the field "Maximum result rows" and save. Note increasing this setting may impact the performance of Foglight so set it to the minimum required to generate the report fully.