Forum Discussion

harshaSampath81's avatar
harshaSampath81
Helper II
9 years ago
Solved

Is it Possible to do Dax Calculations when we use Direct Query ?

Can we perform calucations using DAX if we use DirectQuery in Power BI New Version ?

 

Harsha

General Comment

4 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    Hi harshaSampath81

     

    Yes you sure can, I was actually working on a Power BI Desktop file today that was using DirectQuery to a SQL Server.

  • AlbertoFerrari's avatar
    AlbertoFerrari
    Most Valuable Professional
    9 years ago

    Sure you can, but you will have a set of limitations to live with.

    I suggest you reading this whitepaper: https://www.sqlbi.com/articles/directquery-in-analysis-services-2016/, it applies to SSAS, but PowerBI is, at the end, Analysis Services. Moreover, it contains a lot of technical information, but if you find them overhelming, just skip them and read the sections about the differences between Direct Query vs Import mode.


    Have fun with DAX!

    Alberto Ferrari
    http://www.sqlbi.com

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    9 years ago

    Hi harshaSampath81,

    You can write some DAX functions even in Direct Query mode. You need to select File > Options and then Settings > Options and settings > DirectQuery, then selecting the option *Allow unrestricted measures in DirectQuery mode**. When that option is selected, any DAX expression that is valid for a measure can be used. The functions that are supported vary by data source, but Intellisense will prompt you with only the valid options are you enter your formulas.

    Best Regards,
    Angelia