Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to connect a specific Sharepoint folder?

Hello!   I am having issues to connect a specific Sharepoint folder to PowerBI. I get a 404 error when I enter the full Sharepoint folder url.   Instead, what I can only do, is to enter the Share...
Need Help
  • KNP's avatar
    KNP
    4 years ago

    Hi Anonymous,

     

    You could go directly to a file with...

    Web.Contents("https://yourdomain.sharepoint.com/sites/yoursite/Shared Documents/yourfolderpath/file.extension")

     

    Typically what I do is have two parameters setup, a pSite and pFolder.

     

    The first query I keep as a staging query to pull back all of the required files to be reused in other queries.

    It may seem inefficient but it is not pulling back all of the site files, only the metadata properties.

    // pSite
"https://yourdomain.sharepoint.com/sites/yoursite/" meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=true]

// pFolder
"yourfolderpath/" meta [IsParameterQuery=true, Type="Text", IsParameterQueryRequired=true]

// Query1
let
    Source = SharePoint.Files(pSite, [ApiVersion = 15]),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Folder Path] = pSite & pFolder))
in
    #"Filtered Rows"

     

    Hope this helps.