Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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

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.

Status: Investigating

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:

vrobertqmsft_0-1644371727731.png

 

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

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Comments
v-robertq-msft
Community Support
Status changed to: Investigating

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:

vrobertqmsft_0-1644371727731.png

 

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

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

Jack2of3
Helper II

@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