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
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