Finance | Project Operations, Human Resources, ...

An error occurred while retrieving the row count of entity. User is not authorized to read view.

(0) Share

Report

Posted on by edoscou

Hi there,

I get this error in our Production environment when using Excel workbook designer to pull a data entity using an user access but when I use the same access in a non prod environment, I was able to retrieve records of this data entity. I tried with other entities and had the same issue. I don't find anything on Microsoft Issue search. Hoping someone could share some knowledge here.

Thank you,

All responses (10)

Answers (0)

Sort by

Suggested answer

Waed Ayyad 9,218 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @ Evy Do,

1- Can you check the Security roles assigned to the user may be there are a difference on it?

2- Try another user with the same roles and double check if the same issue is existing?

Thank,
Waed Ayyad

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Suggested answer

Judy Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

This error indicates that the user does not have the necessary authorization to read the view associated with the data entity.

As Mentioned, can you please check if the user has the same roles with the non-prod environment.

If the issue persists, you can log a ticket with Microsoft for further investigation.

Best Regards,

Judy
edoscou 36 on at

Like (0)

Report
Copy link

Link copied!

Hi Judy and Waed,

Yes I used the exact same access in both environments.

Thank you,

Evy
André Arnaud de Cal... 307,145 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi ED,

Can you check if there are differences in enabled configuration keys in both environments?
edoscou 36 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

What configuration keys are you referring to?

Thank you,

ED
André Arnaud de Cal... 307,145 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi ED,

Via System admininstration > Setup > License configuration, you can check which configuration keys are disabled.
edoscou 36 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Some configuration keys are not enabled in our PROD but the same ones are also not enabled in our non prod. I compared the configuration keys between two environments and they are exactly the same.

Thank you,

ED
André Arnaud de Cal... 307,145 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi ED,

Thanks for checking and providing the outcome. Maybe there was an issue during a database sync where a view is not available on SQL server, but this is a guess. You can enforce a database sync by installing a new deployable package or put the environment in maintenance mode, wait for about 10 minutes, and then disable the maintenance mode. If this will not help or you don't want to try this, you can create a ticket for Microsoft.
edoscou 36 on at

Like (1)

Report
Copy link

Link copied!

Thank you Andre.

I raised a ticket with MS. Will update everyone what they recommend.
Suggested answer

edoscou 36 on at

Like (0)

Report
Copy link

Link copied!

Just wanted to update on my post.

Microsoft is unable to explain why D365 behaves differently between environments. However, when I assigned security privileges related to the entity to user in our production environment, the user can pull the data entity.