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 🙂

[idatadrew1]

Definitely needed!!!

[donpaul_dodson1]

Added my three cents (votes) as well. Very crucial in our environments.

[jbrown81]

Definite "must have" feature.

[hagrawal]

Definitely needed!

[pauwnrajpp]

Calculated Fields and Measures must be needed when we go for Connect LIVE to a SQL Database. Please, Include this feature.

[zainuri]

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/ Thank's it already TOP-N in new power BI. 🙂 Cool

[zainuri]

This is really urgent for Bizzy.co.id, can you make this to TOP PRORITITY.. thank you.

[9188040d-6c6257]

Not Completed: but we can't add Measures, Calculated Fields or Calculated Tables...yet. or Calculated Tables is not yet available so this is incomplete.

[fbcideas_migusr]

'@Gijs – it’s been available since earlier this year. If you upgrade to the latest version you’ll see it enabled (though read my other comments below) @Jonathan – One thing I should have pointed out: as per powerbi.microsoft.com/en-us/documentation/p.., we do limit the DAX functions by default but you can allow unrestricted DAX measures under File -> Options and settings -> Options -> DirectQuery. There’s a potential performance impact because you’re pushing all those calculations back down to the source. It’s also why we don’t allow DAX tables – the performance implications are typically too great. But: it's on our backlog too. Most users only use measures and columns so we shipped this feature to them now rather than waiting for all the DAX table support too. @Anton – Sorry if this sounds condescending but please make sure you’re connecting to a SQL relational database using DirectQuery and not to SSAS using ‘Live Connect’ mode. I’ve had a couple of other people get in touch who’re confused by the difference. Our documentation could be clearer on this! SSAS Live Connect is covered here powerbi.microsoft.com/en-us/documentation/p... At the moment you can’t create measures/columns/tables against that either, but we’re working on it. You can add support for that one here ideas.powerbi.com/forums/265200-power-bi-id..

[pbiideas1]

Since which version?