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!

Comments (33)

Comments (33)

Himanshu Agrawal on 05 Jul 2020 22:30:50

RE: Create DAX measures, fields and tables in Direct Query mode

Definitely needed!

Jeremy Brown on 05 Jul 2020 22:29:34

RE: Create DAX measures, fields and tables in Direct Query mode

Definite "must have" feature.

Power BI User on 05 Jul 2020 22:28:50

RE: Create DAX measures, fields and tables in Direct Query mode

Definitely needed!!!

DPD on 05 Jul 2020 22:28:42

RE: Create DAX measures, fields and tables in Direct Query mode

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

Power BI User on 05 Jul 2020 22:25:25

RE: Create DAX measures, fields and tables in Direct Query mode

This is essentially a duplicate of https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/11685723-create-calculated-measures-on-top-of-a-live-ssas-c

Ray on 05 Jul 2020 22:24:54

RE: Create DAX measures, fields and tables in Direct Query mode

With the ability to "Analyze in Excel" this becomes a bigger issue. The new feature is great and connecting to live data will be a huge benefit, but not unless excel can sum up the values. Without measures this feature is useless on live data.

Sunil Grewal on 05 Jul 2020 22:24:36

RE: Create DAX measures, fields and tables in Direct Query mode

How to find new customer in current year comparison with last year with customer name instead of count customers

Please provide the solution

Chris on 05 Jul 2020 22:24:02

RE: Create DAX measures, fields and tables in Direct Query mode

I've added my votes. Also do wish I could add more.

Power BI User on 05 Jul 2020 22:23:49

RE: Create DAX measures, fields and tables in Direct Query mode

I would also put all my votes here if I could.

Daniel Bartley on 05 Jul 2020 22:22:46

RE: Create DAX measures, fields and tables in Direct Query mode

My preference is to be able to define a data source as a Direct Query connection in the Desktop app and then publish the pbix file to the service as normal.