Access denied error to server from BI report

(0) Share

Report

Posted on by Community Member

Dear all,

While building custom report from several days without any trouble, suddenly while configuring a new dataset within BI environment and providing CRM connection credential, I get an Access Denied error to CRM web service url.

Any idea what has gone wrong sudenly ?

I am 100% sure of credential used

Thanks for help

Regards

*This post is locked for comments

I have the same question (0)

All responses (12)

Answers (0)

Bruno Lucas 5,421 on at

Like (0)

Report
Copy link

Link copied!

Does this error show more details. yesterday I had a time zone error because my client machine had a wrong time. Did you try using only the odata end point?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

The error just says it cannot access the web service url, nothing else.

Cannot used odata endpoint as we have a lot of Customer report already working like this

any more clue ?

Was this reply helpful? Yes No
Bruno Lucas 5,421 on at

Like (0)

Report
Copy link

Link copied!

You can try to run fiddler and see if that shows how the endpoint communication is running. It could be something got cached.

blogs.technet.com/.../power-query-sign-in-certificates-and-troubleshooting.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

here is the only error I get :

Access is denied.

----------------------------

The connection to server "https://<account>.crm4.dynamics.com/XRMServices/2011/Discovery.svc" could not be established. Make sure that the connection string and credentials are correct, and try again.

PS : If I place the url in the browser, the service display the description page correctly

regards

serge

Was this reply helpful? Yes No
Saroj Das 3,355 on at

Like (0)

Report
Copy link

Link copied!

HI Sergec,

please paste your discovery service url in browser "//<account>.crm4.dynamics.com/XRMServices/2011/Discovery.svc" and check what you are getting.

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

It displays the service page

Was this reply helpful? Yes No
Saroj Das 3,355 on at

Like (0)

Report
Copy link

Link copied!

Hi Sergec, could you please access the service by enabling Anonymous Authentication. And check whether the problem is in service or in credentials.

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

Same error in anonymous.

I do not know where to look, and have reports to push for customers, really wierd

Was this reply helpful? Yes No
Saroj Das 3,355 on at

Like (0)

Report
Copy link

Link copied!

HI Sergec, do you have ADFS configured ? if yes, sometime it blocks CRM service Communication. Please check once ADFS configuration and credential.

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

What is weird is that it was working few days ago and I did not change anything in my report connection to CRM for using fetch xml data in my report I simply use the connection string below :

https://<account>.crm4.dynamics.com

:-(

Was this reply helpful? Yes No