Datamarts in Power BI is a fully managed SQL database that allows users to easily perform relational database analytics using no-code/low-code. As you all know, we announced Public Preview of Datamarts during Build in May 2022. Since then, we have been working on improving Datamarts with more capabilities based on feedback. Today, we are excited to share the following improvements that we have made to the Visual and SQL Query editor within Datamarts, based on your feedback.
Default query name
When you create a new query within the Visual Query editor or the SQL Query editor, your query gets a default name. For example: Visual query 1, SQL query 1 etc. You can see this default query name displayed in your query tab and the Object explorer.
If you see that the SQL query you are executing is taking too long or is not returning the results you expect, you can cancel the query by clicking the “Cancel” button within the Ribbon, provided it has not already finished.
AutoSave is a feature that is enabled by default for your queries. As you start writing your query within the Visual Query editor or the SQL Query editor, we save the query automatically, every few seconds as you work. You know that your queries are being saved automatically, when you see a “saving indicator” that shows up in your query tab at the bottom. AutoSave ensures that we automatically save drafts without losing your query.
Multiple query tabs
You can now be more productive by working on multiple queries simultaneously using query tabs. You can create new tabs by clicking on the “+ button” in the tab or “+ New query” in the Ribbon. You can easily switch back and forth between query tabs. You can close a query tab that you are not actively working on by clicking the close button. These features are available both within the Visual Query editor and SQL Query editor.
View saved queries
As soon as your query is automatically saved, you can view all your saved queries within the Datamart’s Object explorer on the left. Note that even if the query tab is closed, the saved query shows up in the Object explorer. You can use the queries in the Object explorer to navigate to the query of your choice. Note that when you switch from SQL Query editor to Visual Query editor or vice versa, it remembers the query that you were last working on and is selected in the Object explorer.
Rename and delete
You can rename the default name of your query by double clicking the query name. This will allow you to perform an in-line rename of the query.
You can also choose to rename the query by right clicking the query tab and choosing “Rename” from the context menu action.
You can delete the query by choosing “Delete” from the context menu action. This will display a pop-up to get your confirmation to permanently delete the query. Deleting a query will remove the query from the Object explorer and the query tab.
We are excited to learn how you use these capabilities. Head over to your Power BI Gen 2 Premium workspace and start creating Datamarts and enable other users in your organization to consume using Power BI reports and Ad-hoc analysis using SQL. Learn more about Datamarts here. Please continue to share your feedback through Ideas.