Sharepoint Document ID

[curiouspbix0]

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 and Name combo transformed into an URL downloads the document itself and not open it.

Need to get hold of document ids of the files

O Data feed connector seems not to be authenticating my corporate account for some reason.

Any alternatives

[v-yingjl]

Hi @curiouspbix0 ,

Based on my test, If you want to open the file which stores in SharePoint folder with an URL link in power bi desktop, the URL link should be the shared link not like 'Foldpath + Name':

This link can be opened as an URL link in power bi desktop, the link like 'Filepath + Name' will download the file as you said previously. But it should be inconvenient because you should get the whole files share link manually as a table and import it into power bi desktop if you want to use URL to open it in power bi.

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.

[Mariusz]

Hi @curiouspbix0 

Try this function 
https://docs.microsoft.com/en-us/powerquery-m/sharepoint-contents

Best Regards,
Mariusz

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

Please feel free to connect with me.
LinkedIn

[curiouspbix0]

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

[Mariusz]

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]

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 · Accepted solution]

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