Hands up if you ...

[garythomannCoGC]

Building a simple table of reference constants in pbi desktop.   

Query works in daxstudio but falls over in pbi desktop.

daxstudio

pbi desktop

[ERD · Accepted solution]

Hi @garythomannCoGC ,

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

[garythomannCoGC]

Good.  Now why? :}

[ERD · Accepted solution]

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

[ERD · Accepted solution]

Hi @garythomannCoGC ,

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