Forum Discussion

ktt777's avatar
ktt777
Helper V
6 years ago
Solved

Loading file from sharepoint

Can i load excel file from sharepoint if it is not in any folder like below?  
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi ktt777 ,

     

    Refer to this document, similar to this approach

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rubinboer's avatar
rubinboer
Resolver II
6 years ago

yes you can. open the file with the desktop app (eclipse and open with desktop app) once open in excel go to Info and copy the path to the clipboard. in the datasource within power bi select excel as source and paste the location which you copied to the clipboard as the path https://drherjeilrtjew.xlsx?web=1. remove the ?web=1 part. i am assuming the site is already to IE to allow Power Bi to access SharePoint.

  • ktt777's avatar
    ktt777
    Helper V
    6 years ago

    Thanks. 

     

    I tried that but there is below error when i load the file :

    Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
    OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
    OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
    OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)"

     

    Do you have any idea why ?

    • rubinboer's avatar
      rubinboer
      Resolver II
      6 years ago

      please make sure you select excel as the source and not SharePoint online. the error you get look slike you trying to get data from a SharePoint online list.

      • ktt777's avatar
        ktt777
        Helper V
        6 years ago

        Hi

         

        If i choose Excel as source, where can i paste the link that you mentioned earlier ?

         

        Thanks.