So this is a weird one…

This week I was setting up a new user on our Microsoft Dynamics 365 system. We are currently running this on-premise. I wanted to create a security role just for this user and, having spent far too long getting caught out by this, I copied an existing role and turned off all of the entities I knew the user would replica cartier love bracelet need access to.

Everything was working fine. The user could access the system, including any and all records cartier love bracelet silver sale
I wanted them to have access to. Great!

I wanted to give the user access to a specific report I created in VS that connects directly to my SQL Database but sits in 365. So, I set the report to “Individual” and shared it with the user. Then I hit a problem…Every time the user tried to run the report they would get this…

After doing a bunch of research (google) and going through the steps in this excellent post by Atrio, I still wasn’t having any luck. So I decided to take a closer look at what the Event Viewer on the server was telling me. The specific error it was displaying in EV was:

“Web service request GetParameters to Report fake cartier bracelets
Server http://xrmcrm/reportserver failed. Error: Principal user (Id=a849a49f-0ff3-e611-a958-002248013ec3, type=8) is missing prvReadTransactionCurrency privilege (Id=a84b6eb5-87ec-4574-b8c5-02c880ae3472)”

Currency?? Really?? Bear in mind that my report had absolutely no relation to the currency entity other than it had Contact names showing in it. On checking the security role, the currency entity was missing from the permissions. I gave read access to the role and…

It worked..the user can run the report no problem.

I would love to tell you that I know exactly WHY the user needs read access for currency when it has no bearing on the actual report but I have no idea! My only guess would be that read access to currency records is needed by contact records and, as i was pulling contacts into cartier love bracelet my report, it was needed by the user.

Hope this helps…

Joel Abbott – The xRM Consultant