Forum Discussion

bengisby's avatar
bengisby
Helper I
8 years ago
Solved

Excel Data refresh fails

Hello, I have an on premisis server setup. I want to schedule a refresh of excel data. When setting up the data connection I can't get a successful test connection. Error is "Log on failed. Ensure t...
Scheduled data refresh
  • Martin_H's avatar
    Martin_H
    8 years ago

    Edited:

    Hi,

     

    I also didn't understand which Windows user that one should use to connect to files on a network share (not local path) and got the same error message as bengisby. 

     

    After reading https://docs.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh I did however realise that I had missed to write the domain (is what it's called? I mean the equivalent of contoso\ on the link) and only the user name (john on the link). When I wrote both the domain and the user name it worked.

     

    Best regards

    Martin

     

Martin_H's avatar
Martin_H
Regular Visitor
8 years ago

Edited:

Hi,

 

I also didn't understand which Windows user that one should use to connect to files on a network share (not local path) and got the same error message as bengisby. 

 

After reading https://docs.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh I did however realise that I had missed to write the domain (is what it's called? I mean the equivalent of contoso\ on the link) and only the user name (john on the link). When I wrote both the domain and the user name it worked.

 

Best regards

Martin