Forum Discussion
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 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
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
6 Replies
Hi curiouspbix0
Try this function
https://docs.microsoft.com/en-us/powerquery-m/sharepoint-contentsBest Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedInThanks Marius, where would I invoke this fucntion in Power BI ?
Hi curiouspbix0
Power Query Editor > Create Blank Query > Go to Advanced Editor and Paste the below
let Source = SharePoint.Contents( sharePointPath ) in Sourcewhere 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
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
