Hello there! 👋 I'm Luca, a BI Developer with a passion for all things data, Proficient in Python, SQL and Power BI ...
The DB query is not DISTINCT on PK_FEATUREOFINTEREST. Though, DISTINCT is not allowed as the query selects shapes. A workaround might use ROW_NUMBER function (SQL): ...
Starting from this conversation with Ken I investigated this issue a little more. My conclusion is that there should be an explicit order-by clause at the end of the outer query for windowed results.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results