Forum Discussion
Getting 'One or more table references a dynamic Data Source' even with Web.Contents with Relativepat
And how is that supose to sort the problem?
You will have a static Site URL that will satisfy the "dynamic data source monster". All the dynamic stuff can then happen as if you were using RelativePath.
Its giving the same error, I started with trying to do it with Standard SharePoint List connector and thats why I tried to do it with Web.Contents
In the code you posted "Source0" is not referenced later on, so it won't be executed anyway.
Please avoid sorting tables in Power Query if possible - it is a very expensive operation that breaks spooling.
Can you please describe what kind of business problem you are attempting to solve?
You realy need to learn to pay attention 🙂
Source0 referenced in line 14 -value = Source0[value],
Sorting table is nothing to do with a problem
Problem clearly described in a post subject and description - "Getting 'One or more table references a dynamic Data Source' even with Web.Contents with Relativepat"