Forum Discussion

curiouspbix0's avatar
curiouspbix0
Helper IV
6 years ago
Solved

Sharepoint Document ID

Hello Sharepoint PBI Users,   Am trying to locate where can I find the complete link of documents on sharepoint to load into Power BI estabilishing a link to launch from the PBI report. Folderpath...
Need Help
Show and Tell
Tips and Tricks
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi curiouspbix0 

     

    the quotes  "" need to be around the URL, not the function, please refer to my post, why would you convert it to a table?

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi curiouspbix0 

 

Power Query Editor > Create Blank Query > Go to Advanced Editor and Paste the below

let
    Source = SharePoint.Contents( sharePointPath )
in
    Source

 where sharePointPath needs to be replaced with your actual path https://companyname.sharepoint.com/My_Workspaces/Teams/Workspace_name/

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

curiouspbix0's avatar
curiouspbix0
Helper IV
6 years ago

Converting that to a table is not loading the contents but just the sharepoint path file name as one entry, what am I missing here ?

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi curiouspbix0 

     

    the quotes  "" need to be around the URL, not the function, please refer to my post, why would you convert it to a table?

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn