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

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,

  • Cado_one's avatar
    Cado_one
    Resolver III
    5 years ago

    The refresh on the computer that has the gateway installed works fine.

    The formula "DOMAIN\WindowsLoginUser" must be used as user in the credentials for the file in the manage gateaway settings of PBI Service ? When doing this the connection test is lost.

    On the gateway there is a similar thing : service account  (see screenshot below)

    It says folder not found for the connectors, is it linked ?

     

    Cheers,

    Cado

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi, can you show me how I do that?

     

    I used the formula "DOMAIN\WindowsLoginUser" but doesn't work.

     

    Regards.

    • Cado_one's avatar
      Cado_one
      Resolver III
      5 years ago

      Hi Anonymous 

       

      You have to replace DOMAIN with the name of domain of the computer on which is the gataway installed. And replace WindowsLoginUser by your login on this computer, it's usually your professionnal email adress if the computer is from your company.

       

      Regards,

      Cado