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.