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

[harshaSampath81]

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

Harsha

[v-huizhn-msft]

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

[harshaSampath81 · Accepted solution]

Thanks to All

[AlbertoFerrari]

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

[GilbertQ]

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.