Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
Is it a good idea to delete all existing DAX commands in a Power BI dashboard environment and replace them with SQL code (in SQL server)?
Is this much easier to maintain and do I keep the same flexibilty (drilling, filtering, analysing) in my reports?
Thanks
Hello Amitchandak,
I can't give you an example . It's about the global priciple : Make a dashboard without any DAX, but do all calculations in SQL in SQL server, where SQL server is the source for the dashboards. So for example (there you go....)
eg "Calculate[profit];Company="Acme" -> write SQL code to get the same result
eg "SUMX[Sales];sales[profit] * sales[cost] -> write SQL code to get the same result
and so on.
Does it make sense to write all calculations in SQL?
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
13 | |
12 | |
11 | |
11 |
User | Count |
---|---|
19 | |
14 | |
14 | |
11 | |
9 |