Query with Access code

[Anonymous]

Hi,

I have a query where I need to copy in an access code. The problem is that the maximum numbers of rows is 3000. The code looks like this:

"paging": {
      "page": 1, // page number
      "pageSize": 3000 // rows per page

So if I want to have more than 3000 rows I need more queries. The alternative I can see is reference the first query. But then the page will always be the same. I can also copy the query, but then I need to copy the access code in all queries. Is there any good alternativ I can use to only insert the access code once and still have several queries?

Thanks.

/H

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me what data source you want to connect and what is the connection mode? 

Regards,

Daniel He