Forum Discussion

Cado_one's avatar
Cado_one
Resolver III
5 years ago
Solved

Unusual error when refrshing data on PBI Service

Hi,   Since I changed my personal on-premises data gateway for the standard one, I got troubles refreshing Excel files stored on the server of my company. Here is the error message : Underlying e...
Need Help
Show and Tell
  • ibarrau's avatar
    ibarrau
    5 years ago

    Let's see if the path is broken. Please try refreshing the pbix file INSIDE from computer that has the Gateway installed. That computer or VM must read the path in order to run it from Service. It looks like you have done the test in a computer but the Gateway is hosted somewhere else.
    After working that refresh in that computer. If the error is still there it is a problem of credentials. Be sure to be using the formula "DOMAIN\WindowsLoginUser" as User in Manage Gateway menu under the gateway config.

    Regards,

ibarrau's avatar
ibarrau
Super User
5 years ago

Please remove the "Ignore test conection" in order to check if the Service can reach the file. That will show us the error. If the credentials are wrong it will say it, and if the path is wrong it will be a different message. We'll see with that new error message.

Regards,

Cado_one's avatar
Cado_one
Resolver III
5 years ago

Indeed this error message appeared when unticking the "ignore test connection" :

Translation : Could not connect. We encountered an error while trying to connect to .

 

How to deal with that ?

Do you think it has something to do with the fact that the path begins with //files/... ?

 

Edit: I've found the good credentials and the connection is OK. However the refresh still returns the error from 1st message

Regards,

Cado