Forum Discussion

po's avatar
po
Post Prodigy
6 years ago
Solved

Connecting to sharepoint data source

Hi,   Have a working report which uses sharepoint as a source but to get this to work I had to connect to the all documents on the site and filter them and select file etc. resulting power query b...
Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi po ,

    If you want to get one specific file in SharePoint folder, I would suggest you to use Web connector instead of SharePoint connector to save some time.

    URL will be like:

    https://xxxx.sharepoint.com/sites/xxxx/Shared Documents/<file name>

     

    Best Regards,
    Yingjie Li

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

v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi po ,

If you want to get one specific file in SharePoint folder, I would suggest you to use Web connector instead of SharePoint connector to save some time.

URL will be like:

https://xxxx.sharepoint.com/sites/xxxx/Shared Documents/<file name>

 

Best Regards,
Yingjie Li

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

  • po's avatar
    po
    Post Prodigy
    6 years ago

    Hi,

     

    Thanks for suggestion.

     

    This looks to work but I had to go to teams and right clcik the link suchh that it accepts the url with %20 otherwise it was syaing invlaid URL.

     

    https://<company>.sharepoint.com/sites/BI/Shared%20Documents/Power%20BI/Workspace%20Inventory/workspaces.csv

     

    Also,  chose organization and auth2 on the service.

     

    Only thing is though if my password changes then will need to update the credentials.

     

    Not sure what shoudl put for this - any thoughts and recommendations for this part?