Direct Query Slicer Search mode appending an alias to table in Select and failing

[Jack2of3]

Only fails in Direct Query when Search is enabled. Works fine in import.

Diagnostic:

DEFINE
VAR __DS0Core =
VALUES('TA_ITEM_CATALOG'[ITEM_CODE])

VAR __DS0PrimaryWindowed =
TOPN(101, __DS0Core, 'TA_ITEM_CATALOG'[ITEM_CODE], 1)

EVALUATE
__DS0PrimaryWindowed

ORDER BY
'TA_ITEM_CATALOG'[ITEM_CODE]

// Direct Query

SELECT * FROM (
SELECT
"t0"."ITEM_CODE"
FROM
(
(
Select ITEM_CODE FROM M3_REPORT_USER.TA_ITEM_CATALOG
)
)
"t0"
GROUP BY "t0"."ITEM_CODE"
ORDER BY "t0"."ITEM_CODE"
ASC
) WHERE ROWNUM <= 101

Release:
December 2021

Product Version:
2.100.1182.0 (21.12) (x64)

Error Message:
ORA-00904: "t0"."ITEM_CODE": invalid identifier. The exception was raised by the IDbCommand interface.

[v-robertq-msft]

Hi,

What does the DAX formula you used to create? Calculated column/table and measure?

If you are using this to create a calculated column/table, I think this is a limitation of the DAX Values() function:

https://docs.microsoft.com/en-us/dax/values-function-dax

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

[Jack2of3]

@v-robertq-msft  No dax code. Simple SQL select from the source, add a slicer visual and click the field to be used by the slicer