Dynamic data source error

The OData.Feed() functions allows you to add headers and parameters dynamically outside of modifying the URL.

• Edit: after rechecking the documentation and your description I have come to realise that OData.Feed() doesnt have the RelativePath modifier, so it won't solve your use-case because you need to modify the base URL.

The basic syntax is:

OData.Feed(serviceUri as text, optional headers as nullable record, optional options as any)

What you want to do is to add your dynamic value parameters as options or headers instead of injecting them into the serviceUri directly.

Aside from being a different function with slightly different syntax—the solution remains somewhat the same to what Laura describes in her blog post:

https://hatfullofdata.blog/power-query-dynamic-data-source-and-web-contents/

Also, check out the MS documentation that explains the function and its options in details:

https://learn.microsoft.com/en-us/powerquery-m/odata-feed