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!

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Mitanshu 1,658 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Cosmic_Kitchen 105 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
erea 39 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
RobAGR 2 on at

Like
a
(1)

Report
Copy link

Link copied!

I am having the same issue. Pagination causes failure.

Was this reply helpful? Yes No
erea 39 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
arxvn 4 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
arxvn 4 on at

Like
a
(1)

Report
Copy link

Link copied!

Switch from list rows from select environment to list rows.

Was this reply helpful? Yes No
Suggested answer

Matthew 9 on at

Like
a
(1)

Report
Copy link

Link copied!

This seems to be fixed today.

Was this reply helpful? Yes No