Cannot get DESCRIPTION from MDSCHEMA_MEASURES

Galapo, Hila (Cognizant) 5 Reputation points
2023-03-09T01:18:07.3366667+00:00

In Power BI Model,

Running the following query in DAX Studio works really well:

select * 
FROM $SYSTEM.MDSCHEMA_MEASURES

If I try to change it to list specific columns the way I want to, for example:

SELECT measure_cAption FROM $SYSTEM.MDSCHEMA_MEASURES

It works.

But not if I want DESCIPRION!

SELECT measure_cAption, DESCRIPTION 
FROM $SYSTEM.MDSCHEMA_MEASURES

returns an error.

What am I missing? Or is this a bug?

Many thanks!

Can list all the columns

Being Specific: Cannot recognize the DESCRIPTION column name

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,868 questions
{count} vote