401 Unauthorized error with Dataverse List Rows after enabling pagination

(2) Share

Report

Posted on by Cosmic_Kitchen

105

I'm working in a Logic App, but I get this same error in Power Automate.

I am trying to return more than 5000 records from a Dataverse List Rows action and have turned on pagination and set the threshold to 100000. I am receiving a 401 error so assuming it is not refreshing the token for the subsequent requests? Are there org settings I need to enable in order to use paginated results from Dataverse?

Thanks in Advance!

All responses (8)

Answers (0)

Suggested answer

Matthew 9 on at

Like (1)

Report

401 Unauthorized error with Dataverse List Rows after enabling pagination

This seems to be fixed today.
arxvn 4 on at

Like (1)

Report

Re: 401 Unauthorized error with Dataverse List Rows after enabling pagination

Switch from list rows from select environment to list rows.
arxvn 4 on at

Like (1)

Report

Re: 401 Unauthorized error with Dataverse List Rows after enabling pagination

It works for list rows, it fails on list rows from select environment
erea 39 on at

Like (1)

Report

Re: 401 Unauthorized error with Dataverse List Rows after enabling pagination

In case this helps anyone, we figured out the issue though don't have a direct resolution.

Pagination works fine when you use "List rows", but pagination does not go passed 5000 rows for "List rows from selected environment". Very annoying and not sure if its intended or an oversight.

Just FYI that to get around it, I had to do an alphabetical loop to pull all records that start with A, then B, then C, etc.
RobAGR 2 on at

Like (1)

Report

Re: 401 Unauthorized error with Dataverse List Rows after enabling pagination

I am having the same issue. Pagination causes failure.
erea 39 on at

Like (1)

Report

Re: 401 Unauthorized error with Dataverse List Rows after enabling pagination

I am currently experiencing the same issue. Was there ever a solution? I am assuming its a setting somewhere as everything i read says that you should be able to pull up to 100k records.
Cosmic_Kitchen 105 on at

Like (1)

Report

Re: 401 Unauthorized error with Dataverse List Rows after enabling pagination

Thanks for the reply!

I am using a service principal with system admin privileges and I have also attempted with my own credentials which also has system admin.
The action works consistently for 5000 rows or less when pagination is turned off, and fails consistently with pagination turned on.
Mitanshu 1,635 Super User 2025 Season 1 on at

Like (1)

Report

Re: 401 Unauthorized error with Dataverse List Rows after enabling pagination

Can you confirm that the connection is still valid ?

Has the credential changed/refreshed (for example user has changed their account password)?

Does the authenticated user still have the permission to do the READ operation?

If you try to retrieve only a single row, does that remove the error?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.