Skip to main content
Microsoft Idea

Power BI

Needs Votes

Odata.Feed should have RelativePath as an option the same as Web.Contents.

Vote (13) Share
Robert Charlton-Ward's profile image

Robert Charlton-Ward on 11 Mar 2021 15:55:51

This would be very useful to avoid "dynamic query" errors when refreshing on the web service.

As it is, calling an API that has a slightly different endpoint to request an authentication token than it does for the main request means the query gets treated as having two separate sources, which is a no-no on the web service.
Being able to specify a relative path to both endpoints from the base URL would mean it was treated as one source and no longer be considered a dynamic query.

Comments (2)
Robert Charlton-Ward's profile image Profile Picture

Roman Fianta on 06 Jun 2022 15:16:40

RE: Odata.Feed should have RelativePath as an option the same as Web.Contents.

Same here. We provide OData API which brings great flexibility to our customers, but at the same time we need to encourage our customers to implement incremental refresh in their reports - but incremental refresh does not work with dynamic queries, and since OData does not support RelativePath, the customers will have to use Web.Contents instead.

Robert Charlton-Ward's profile image Profile Picture

Nicolas Emmerich on 01 Oct 2021 03:50:46

RE: Odata.Feed should have RelativePath as an option the same as Web.Contents.

This is extremely important for us as well. We've built an OData feed provider for MYOB and Xero but we need to have the ability to have a main root path and a relativepath (similar to Web.Contents) in order to be able to provide the ability to automatically consolidate data.