Forum Discussion

obesli's avatar
obesli
Frequent Visitor
8 years ago
Solved

Excel file schedule refresh problem

I have an excel file on sharepoint to use in reports. When I want to scheduling I got this type of error. What can I do for this error?

 

 

 

 

 

 

 

 

Power BI Report Server
  • Anonymous's avatar
    Anonymous
    8 years ago

    Is your connection string using a mapped drive letter (e.g. W:\MyFile.xlsx)?

     

    If so this won't work, you'll need to use a UNC path (e.g. \\MyServer\MyFile.xlsx).

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Is your connection string using a mapped drive letter (e.g. W:\MyFile.xlsx)?

     

    If so this won't work, you'll need to use a UNC path (e.g. \\MyServer\MyFile.xlsx).

    • obesli's avatar
      obesli
      Frequent Visitor
      8 years ago

      Your proposal works well, dataconnection section test connections are all ok. But when I want to refresh the data in the scheduled refresh section then I got this error. 

       

      Do you have any idea about this?

       

      "Credentials are required to connect to the SharePoint source. (Source at http://intranet.). The exception was raised by the IDbCommand interface."

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Glad you got over the first issue.

         

        The error you're now seeing looks like a permissions issue. Can you confirm the credentials you are using to read the Excel file have the correct permissions assigned?