Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Can we perform calucations using DAX if we use DirectQuery in Power BI New Version ?
Harsha
Solved! Go to Solution.
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
Thanks to All
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
Yes you sure can, I was actually working on a Power BI Desktop file today that was using DirectQuery to a SQL Server.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
104 | |
77 | |
67 | |
63 |
User | Count |
---|---|
144 | |
107 | |
105 | |
82 | |
69 |