New to Telerik UI for WPF? Start a free 30-day trial
>tip Check the [Using XmlaDataProvider](slug://radpivotgrid-data-xmla) and [Using AdomdDataProvider](slug://radpivotgrid-data-adomd) to see how to set up the provider.
Distinct Values Limit
Updated on Sep 24, 2025
The providers that derives from OlapDataProvider (XmlaDataProvider and AdomdDataProvider) has a default limit of 1000 distinct values that will be fetched from the database. This limit is set on purpose to avoid accidental performance hits. You can alter this limit by setting the DistinctValuesLimit property of the provider.
XAML
<pivot:XmlaDataProvider DistinctValuesLimit="5000">>tip Check the [Using XmlaDataProvider](slug://radpivotgrid-data-xmla) and [Using AdomdDataProvider](slug://radpivotgrid-data-adomd) to see how to set up the provider.