Power BI

Completed

Create DAX measures, fields and tables in Direct Query mode

Vote (385)

Miguel Escobar on 28 Oct 2015 07:43:41

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 :)

Administrator on 16 Nov 2016 01:36:58

Hi everyone. This has actually been available for a while, sorry we never updated the Idea! You can write some DAX functions even in Direct Query mode. The functions that are supported vary by data source, but Intellisense will 'prompts' you with only the valid options are you enter your formulas. Please note it's not the same as creating measures over connection to Analysis Services models - we're still working on that, you can add support for that here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11685723-create-calculated-measures-on-top-of-a-live-ssas-c Thanks for voting!