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


Correlation Id: d9b7762b-f21e-1048-e33e-ca558a36c08e
Error Details: Query (2, 1) Failed to resolve name 'TMSCHEMA_MEASURES'. It is not a valid table, variable, or function name.

BeaBF's avatar
BeaBF
Super User
1 year ago

saud968 Can you paste a screen of your view in Dax Studio? on the left you should have the view and the measures, try to drag and drop the view or the measure into the code box. 

 

BBF 

  • saud968's avatar
    saud968
    Memorable Member
    1 year ago

    Here is the screenshot

  • BeaBF's avatar
    BeaBF
    Super User
    1 year ago

    saud968 and a screen of the data model

     

    BBF

  • saud968's avatar
    saud968
    Memorable Member
    1 year ago

    here it is 

     

  • BeaBF's avatar
    BeaBF
    Super User
    1 year ago

    saud968 ok, so in the EVALUATE expression, you need to use the Table Name in this Data Model. Try for example: 

    EVALUATE Bookings. it will work. You need to use the Table Name of the Model.

     

    BBF

  • saud968's avatar
    saud968
    Memorable Member
    1 year ago

    These are my measure table