UsePagination
Whether or not the CData ADO.NET Provider for Microsoft Excel Online should use client side paging.
Data Type
bool
Default Value
false
Remarks
Whether or not the CData Power BI Connector for Microsoft Excel Online should use client side paging. We suggest you set this to true in case of a large dataset.