Create and run DAX queries with Query view in Power BI Desktop
Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned
|Enabled for||Public preview||General availability|
|Admins, makers, marketers, or analysts, automatically||Nov 30, 2023||-|
Professional BI developers can write and run DAX queries natively within Power BI. Previously, as DAX queries is an existing feature, a BI developer would have needed to use third party external tools or use an API in order to write and run DAX queries. Now, they can write and run DAX queries natively in Power BI in context and with additional tools to quickly get started and productively use DAX queries.
The DAX query view allows BI developers to create and run DAX queries in Power BI! Use the existing DAX query syntax to quickly query your data model.
DAX expressions are used to define any measure, calculated column, calculated table, dynamic format string, calculation item, and row level security on your model. But that is not all you can do with DAX. With the DAX EVALUATE keyword, you can also use DAX to create a DAX query. This is much like a SQL query where you can specify columns and aggregations to return in a result table. You can learn more about DAX queries at DAX queries.
This powerful way to interact with your data model will be available in the new DAX query view! We give you several ways to help you be as productive as possible with these DAX queries:
- Quick queries in the context menu of the Data pane tables, columns, or measures gives you a head start by creating a DAX query to preview data or show summary statistics to help you understand the data without creating visuals and for DirectQuery you no longer must go back to Power Query to see some sample data.
- Right-click in the Data pane to get the DAX expression of all measures or a specific measure in a DEFINE statement with an EVALUATE statement to run as a DAX query and add any additional columns.
- If you modify that DEFINE measure from the model definition, a time saving option to update model can overwrite the current model definition with your changes – you don’t have to copy paste it back manually.
- If you use DEFINE to create a measure not in the model already, a time saving option to add to model can be used to add this measure to your model! Again, saving you the step of going new measure and then copy pasting the DAX expression over.
- If your measure references another measure, you can define the measure and all the references, meaning all the measures DAX expressions are visible on one screen! Now you can see the full context of how this measure is calculated from the source columns.
- Performance Analyzer already lets you copy the visual DAX query. Now you no longer need to take that DAX query and use another tool to view and run it – simply run the visual DAX query in Power BI.