Forum Discussion
Sharepoint connection with Web Contents
Hello - I have done a lot of work with PowerBI and Sharepoint sources that bypass the dynamic data source issue. Note, I do not use the Web.Contents function so if you are specifically looking for that then this post won't help. If you are open to other ideas, here is a link that describes the process. Note, the linked post is for combining files from various Sharepoint paths but the basic process would be the same to get the data from the lists.
Hello jennratten
Thanks in advance for the reply.
Unfortunetely I think that your solution won't work in my case.
You're using the Sharepoint.Files() connector, whereas I need to use the Sharepoint.Tables() connector to get the list content.
However, when using the Sharepoint.Tables() I can't find the path to the Subsites from my Sharepoint Root.
I've created a table containing all the subsites's paths and a Function based on a query to one of those subsites.
However, when I "Invoke" the function, I've got the issue with the datasources.