Forum Discussion

curiouspbix0's avatar
curiouspbix0
Icon for Helper IV rankHelper 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

     

  • curiouspbix0's avatar
    curiouspbix0
    Icon for Helper IV rankHelper IV
    6 years ago

    Thanks Marius, where would I invoke this fucntion in Power BI ?

    • Mariusz's avatar
      Mariusz
      Icon for Community Champion rankCommunity 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
        Icon for Helper IV rankHelper 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 ?