Forum Discussion

kroman's avatar
kroman
Icon for Helper II rankHelper II
1 year ago

Getting 'One or more table references a dynamic Data Source' even with Web.Contents with Relativepat

Hi All I have a simple query where trying to get a site url from one item in SP list and then get files list from that site, by following code: let Source0 = Json.Document(Web.Contents("https:...
Need Help
kroman's avatar
kroman
Icon for Helper II rankHelper II
1 year ago

And how is that supose to sort the problem?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

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.

  • kroman's avatar
    kroman
    Icon for Helper II rankHelper II
    1 year ago

    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

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      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?

      • kroman's avatar
        kroman
        Icon for Helper II rankHelper II
        1 year ago

        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"