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

Hi. The error specifies that one or more of the excel files can't be found. The way of the address/url to the file might be wrong. Check the manage gateway settings to see if the source's connections are tested.

You can go to schedule refresh of the dataset under data gateway and see how the address are built in the file for it. There is a problem with that. It can also be because the VM with the gateway installed can't reach the file.

Hope this helps,

  • Cado_one's avatar
    Cado_one
    Resolver III
    5 years ago

    Hi ibarrau ,

     

    thanks for the answer. The gateway is online and the connexion with the file is OK (see screenshot below)

    The path specified is OK and it's the same path on Power BI desktop (working normally here)

     

    Could you tell me more about the VM that can't reach the file ?

    I suspect the credentials to be the problem, I didn't need credentials when I used Personal mode gateway but in standard mode it doesn't look like an option  and I'm not sure of what I should put inside ...

     

    Best regards,

    Cado