Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Hands up if you ...

Building a simple table of reference constants in pbi desktop.   

Query works in daxstudio but falls over in pbi desktop.

 

daxstudio

 

pbi desktop

 

 

Help with DAX

3 Replies

  • ERD's avatar
    ERD
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Hi Anonymous ,

    Remove 'EVALUATE' from your table definition in pbi desktop.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Good.  Now why? :}

    • ERD's avatar
      ERD
      Icon for Community Champion rankCommunity Champion
      3 years ago

      EVALUATE is a keyword automatically included by Power BI in every query. It’s used to answer and create your visuals in Power BI.