Forum Discussion
Solved
column ref to 'createdon' cannot be used with a variation 'Date' because it does not have any.
Hi There, new to Power BI and looking for a little help/advice on this error. we have 2 different reports created in Desktop, 1 is using direct Query, and the other Import for the data. the ...
I think switching to import should be the last resort, I'd suggest rewriting current syntax using DATEADD to something using e.g. FILTER etc. - if possible
can you share the syntax that gives the error & the structure of the tables included?
Stachu
Community Champion
Community Championis it time intelligence related measure? they do not work in Direct Query
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery#limitations-of-directquery
https://docs.microsoft.com/en-us/sql/analysis-services/tabular-models/dax-formula-compatibility-in-directquery-mode-ssas-2016?view=sql-server-2017