Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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