Forum Discussion

saud968's avatar
saud968
Memorable Member
1 year ago

Dax Studio Error

Hi  I am getting the below error as per the screenshot  Actual error  Correlation Id: 45e64fd5-8acd-738e-e54d-c8610e9ec64d Error Details: Failed to get the column type at index 0 from th...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
saud968's avatar
saud968
Memorable Member
1 year ago

Got this error


Correlation Id: d9b7762b-f21e-1048-e33e-ca558a36c08e
Error Details: Query (3, 1) The syntax for 'TMSCHEMA_MEASURES' is incorrect. (EVALUATE
SELECTCOLUMNS(
$SYSTEM.TMSCHEMA_MEASURES,
"ID", [ID],
"Name", [Name]
)).

BeaBF's avatar
BeaBF
Super User
1 year ago

saud968 Sorry, try with:
EVALUATE
SELECTCOLUMNS(
$SYSTEM.TMSCHEMA_MEASURES,
"MeasureID", $SYSTEM.TMSCHEMA_MEASURES[ID],
"MeasureName", $SYSTEM.TMSCHEMA_MEASURES[Name]
)

BBF

  • saud968's avatar
    saud968
    Memorable Member
    1 year ago


    Correlation Id: d9b7762b-f21e-1048-e33e-ca558a36c08e
    Error Details: Query (4, 39) The syntax for '[ID]' is incorrect. (EVALUATE
    SELECTCOLUMNS(
    $SYSTEM.TMSCHEMA_MEASURES,
    "MeasureID", $SYSTEM.TMSCHEMA_MEASURES[ID],
    "MeasureName", $SYSTEM.TMSCHEMA_MEASURES[Name]
    )).

    Got the above error

    • BeaBF's avatar
      BeaBF
      Super User
      1 year ago

      saud968 ok, so let's debug the code to see the error.

      Run a simple query to inspect the column names in $SYSTEM.TMSCHEMA_MEASURES:

      EVALUATE
      $SYSTEM.TMSCHEMA_MEASURES

       

      and paste the result.

       

      BBF

      • saud968's avatar
        saud968
        Memorable Member
        1 year ago


        Correlation Id: d9b7762b-f21e-1048-e33e-ca558a36c08e
        Error Details: Query (2, 1) The syntax for 'TMSCHEMA_MEASURES' is incorrect. (EVALUATE
        $SYSTEM.TMSCHEMA_MEASURES).