Solved: Error connecting to Excel

mokhawaja · ‎04-18-2017

hi

when i tyry to connect any entity in my CDS database it gives me this error:

Error Loading Metadata

Details:
Please check server connection, verify the current user has proper access, and try again. Error message: 'The request timed out waiting for a response.'

although i recently activated a trial and assigned my self to a license.

thank you for help

Khawaj

somberg · ‎05-23-2017

Hi Khawaj,

Are you still having issues connecting via Excel. Check to ensure your signing into the Add-in as the same user you signed into CDS with. In addition if you do see the error again could you possible take a screen shot of the settings page (the settings wheel next to your name in the Add-in toobar). Thanks.

-steve

View solution in original post

v-yamao-msft · ‎04-19-2017

Hi Mokhawaja,

Please click the OK button, and sign out then sign in again to see if it works.
Or you could close this Excel sheet and re-open the entity in Excel to see if it works.

The first time I open an entity in Excel, I get the same error with you.
Then I click the OK button and sign out then sign in, then provide my credentials, it works.

Please try it on your side. If you are still getting this issue, please feel free reply.

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mokhawaja · ‎04-19-2017

hi @v-yamao-msft,

thank you for your reply... only i need to make some more clarification on what happened with me so everyone can benefit from it, and allow Microsoft to further check on this issue.

i think (and i am not sure about this explanation) that after i did a resources import into my environment from another tenant, i started to see the connection problem with Excel, and what appeared to resolve it is that i deleted the environment, then created a new one with new database then the same error appeared, then used your steps, and it connected normally (by the way i tried your steps several times before deleting my old environment without result).

thanks.

mokhawaja · ‎04-21-2017

Hi @v-yamao-msft,

i still see the error... but i have to sign-in and out, several times until it connects... which is so frustrating, is this some kind of a bug or something?

kind regards,

Mohammad Alkhawaja

v-yamao-msft · ‎04-23-2017

Hi Mokhawaja,

Thanks for your feedback.

When testing this issue on my side, I am also asked to sign-in and sign-out several times until it connects successfully.

I will report this issue from my side and hope it can be smoother.

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yamao-msft · ‎04-24-2017

Hi Mokhawaja,

I have reported this issue on my side, PGs are working on it.

I will keep an eye on this issue and back to you once I got any updates.

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mokhawaja · ‎04-24-2017

thanks a lot @v-yamao-msft... your help is always appreciated.

best regards,

Mohammad Alkhawaja

Anonymous · ‎04-25-2017

We have come across this error in the last couple of weeks.

We have Sophos antivirus and believe it may be the problem as it does not occur when using computers without Sophos.

As it was working up until a couple of weeks ago, I think it is probably due to a Sophos update, however have found no way to resolve this yet.

Didn't check operating systems were the same.

Removed sophos, however the error persisted.

Works with windows 10 machines, does not work with windows 7.

mokhawaja · ‎04-25-2017

thank you @Anonymous for your post... regarding Sophos, i never had it on my machine... i think the problem is either within Excel, or most propably the Powerapps add-in.

regards.