Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / An error occurred whil...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by edoscou 36
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,
ED
  • Suggested answer
    edoscou Profile Picture
    edoscou 36 on at
    An error occurred while retrieving the row count of entity. User is not authorized to read view.
    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. 
  • edoscou Profile Picture
    edoscou 36 on at
    An error occurred while retrieving the row count of entity. User is not authorized to read view.
    Thank you Andre.
     
    I raised a ticket with MS. Will update everyone what they recommend. 
     
     
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,883 Super User 2024 Season 2 on at
    An error occurred while retrieving the row count of entity. User is not authorized to read view.
    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 Profile Picture
    edoscou 36 on at
    An error occurred while retrieving the row count of entity. User is not authorized to read view.
    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 Calavon Profile Picture
    André Arnaud de Cal... 291,883 Super User 2024 Season 2 on at
    An error occurred while retrieving the row count of entity. User is not authorized to read view.
    Hi ED,
     
    Via System admininstration > Setup > License configuration, you can check which configuration keys are disabled.
  • edoscou Profile Picture
    edoscou 36 on at
    An error occurred while retrieving the row count of entity. User is not authorized to read view.
    Hi Andre,
     
    What configuration keys are you referring to?
     
    Thank you,
     
    ED
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,883 Super User 2024 Season 2 on at
    An error occurred while retrieving the row count of entity. User is not authorized to read view.
    Hi ED,
     
    Can you check if there are differences in enabled configuration keys in both environments?
  • edoscou Profile Picture
    edoscou 36 on at
    An error occurred while retrieving the row count of entity. User is not authorized to read view.
    Hi Judy and Waed,
     
    Yes I used the exact same access in both environments.
     
    Thank you,
    Evy
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    An error occurred while retrieving the row count of entity. User is not authorized to read view.
    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
  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 6,695 Super User 2024 Season 2 on at
    An error occurred while retrieving the row count of entity. User is not authorized to read view.
    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
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,883 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans