Showing results for 
Search instead for 
Did you mean: 
Hansi Frequent Visitor
Frequent Visitor

Query with Access code



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?





v-danhe-msft Super Contributor
Super Contributor

Re: Query with Access code

Hi @Hansi,

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



Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 358 members 3,966 guests
Please welcome our newest community members: