The new DAX query editor in Power BI is like unleashing a SQL query wizard ๐งโโ๏ธ. It gives you the power to write, edit, and see DAX queries in action. Plus, you can even copy-paste results right into Excel with just a click ๐. With this tool, you can dissect your data model like a pro and even create new measures on the fly. Power up your data analysis game with this game-changing feature! ๐ฅ
๐ Introduction
hello everyone and welcome to another bi Consulting Services video my name is Brad and today I’m very excited to walk you through one of the most significant updates to powerbi in some time the Dax query editor.
๐ How to Enable Dax Query Editor
We’ll review how to enable this feature look at the UI and work through some of the functionality so let’s take a look if you haven’t already you’ll first want to enable the Dax query editor by heading to the settings gear click preview features and select Dax query view click okay and you’ll be prompted to restart powerbi.
๐งฐ Dax Query Editor Interface
Once you’re back up and running you’ll see we now have this Dax icon on our left toolbar click again and we land on the Dax query editor UI. If we look at our interface here we see some editing and formatting options up at the top including format query comment uncomment and some others over to the right we’ll see our data tables populate once we make a data source connection and down below we have our query tabs where we can create save and even name multiple queries.
๐ Functionality of Dax Query Editor
The documentation provided by Microsoft states that the Dax query view gives you the ability to write edit and see the results of Dax queries on your semantic model Additionally the Dax query view allows you to create Dax queries this is different than the Dax formulas used to create measures and calculated columns basically what we have here is similar to a SQL query editor that will allow us to view data in our model.
๐ Utilizing the Store Sales PBX file from Microsoft
In order to take this editor for a spin we’re going to utilize the store sales PBX file from Microsoft. This file will help us understand the various functionalities and capabilities of the new Dax Query Editor.
| Action | Description |
|---|---|
| ‘Run’ Button | Returns results of the select statement in SQL. |
| Right-click on Table | Use the ‘Quick Queries’ option to display the chosen data. |
๐ Enhanced Features of Dax Query Editor
Another great feature of this editor is that you can easily copy-paste results right into Excel by clicking this copy button opening Excel and pasting right into the sheet.
๐ก Insightful Analysis using Dax Query Editor
If we want to see how many stores we have in each size in our model we have a measure called store count that we can find by using the search bar here. Let’s go into our quick queries and evaluate to open a new query.
๐ Updating Data Model
We see the results update and by using our search function we can see that the new measure has been added to our model.
๐ฎ Conclusion
It’s an exciting development in the world of Power BI, and I’m eager to see how Microsoft continues to enhance this feature. As always, if you have any questions about this content or would like the BX team to cover a topic in a future video, please leave a comment below.
๐ Key Takeaways
- The Dax query view in Power BI allows users to write, edit, and see the results of Dax queries.
- It is different from the Dax formulas used to create measures and calculated columns.
- The Dax Query Editor provides an interface similar to a SQL query editor for viewing data in the model.
FAQ
Q: How can I enable the Dax Query Editor in Power BI?
A: To enable the Dax query editor, head to the settings gear, click preview features, and select Dax query view. After clicking ‘okay’, restart Power BI to enable the feature.
EN_GB