Forum Discussion
Sharepoint Document ID
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
Hi curiouspbix0
Try this function
https://docs.microsoft.com/en-us/powerquery-m/sharepoint-contents
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Thanks 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.
LinkedInConverting that to a table is not loading the contents but just the sharepoint path file name as one entry, what am I missing here ?
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