Create DAX measures, fields and tables in Direct Query mode

[miguel_escobar]

Something new came out just a few weeks ago. We now have the ability to connect LIVE to a SQL Database and use Power Query to create our Query that will later be used in our Power BI Desktop. This is simply AMAZING!! this uses the new SSAS Tabular engine in Direct Query mode, but we can't add Measures, Calculated Fields or Calculated Tables...yet. This should be a fairly simple request. Please let us add our measures so we can create the Model that we need in real time 🙂

[afernando1]

This is the most rediculous response that I've ever seen. I don't see any option to add a measure or a table when I'm connected to a SQL server but the request is marked as complted. I think this is what appens when people start show too much love. Very dissapointed!

[9188040d-6c6257]

But you cant add a DAX query table in Direct query mode. When in direct query mode for instance there is NO way to create a date table using DAX

[jonathans4]

"This has actually been available for a while" - did you actually read the suggestion? "DAX measures, fields and tables in DirectQuery", not "a few DAX functions".

[marek_szulen]

"Function 'IF' is not allowed as part of calculated column DAX expressions on DirectQuery models." - seriously? I want to calculate something without affecting the SQL server source. Same when trying "FORMAT", for example: FORMAT(WEEKNUM(KPI_TAT_DATA[First_ACK],21),"00")