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)

7a508c3f 068e-4cb1-8be4-bd89cda47363 on 05 Jul 2020 22:30:50

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

Definitely needed!

75647672 86fa-44a4-876a-b038ada1e724 on 05 Jul 2020 22:29:34

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

Definite "must have" feature.

ac01b3e8 bce7-4da5-a96e-fd58697875cd on 05 Jul 2020 22:28:50

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

Definitely needed!!!

459ccadb 00b0-450b-bc2d-74108027ad0a 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.

64d831e1 d3eb-4fba-b6b5-495a49298d5f 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

d89b1cc5 6b2f-4a09-9a75-1276db9904c9 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.

df514c7b 8d4d-4f1e-8fb1-d016be1ae5bf 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

98f0fa0e f67d-4e52-94a7-470dc9351923 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.

1a9cdab9 9fe1-4d2e-a1d9-85da77f5e651 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.

6a058b1f 473c-4053-aca8-a85f5d4019dc 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.