CouchBase record fetch

I am fetching 10 M records from couchbase in single select query with proper covering index in power BI. But after some time it’s showing issue time out, or index scan timed out. Please help me out how i can fetch 10 M records in power BI.

select name, Number from user;

By default Index Scan timeout is 2min to avoid keeping indexer snapsot longtime which can impact cluster performance.

10 M records fetch takes time.
You can use different techniques.

  1. Use different queries and Pagination. May be keyset pagination
  2. Use document keys through the N1QL and get the actual documents through SDKs.
  3. Increase Indexer timeout Index scan timed out