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 🙂

[aavilap]

Agree! Latest update only addresses the adding measures limitation, but tables and multi-relation between them is also necessary!!

[emteka]

Direct Query mode with SQL Azure database - not able to add new column using DAX like WEEKNUM or FORMAT. The option to use unrestructed DAX in Direct Query mode switched on

[paula_virmasalo]

I would like to combine different cubes (Tabular and Multidimensional) without importing data. At this moment it is impossible to create Dashboards with different cube datasources and just one common slicer. We can't import all the data (nor we want to).

[daniel_bartley6]

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.

[BrentA]

I need to be able to create calculated columns on direct queries! Such a limitation here!

[rodolfo_ruiz]

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

[sunil_grewal]

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

[back5576]

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

[rayishome1]

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.

[evan_wallace]

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