Execute Query (F5) - Run Selected DAX query if Selected, otherwise run All (Mimic DAX Studio & SSMS Behavior)

[corycundy]

Is your feature request related to a problem? Please describe

The feature is related to a development behavior many have acquired over time in which F5 (or some shortcut key) can be used to either run all of the queries in an open query window or the selected query.

DAX Studio has this functionality split between Execute and Execute Selection. There are so many times when I highlight a single query of many and press F5 and inadvertently run all of the queries, which can be undesirable.

Describe the solution you'd like

I would prefer some setting or in some way to have the ability of the Execute (F5) to run the queries selected if there are any selected, otherwise run all the queries in the query window. This would mimic the behavior in DAX Studio and SQL Server Management Studio in which I would guess many TE3 users have a history with.

I don't believe the current split of functionality between F5 and Shift F5 allows a way to configure the desired behavior

Goals

1. Even if this isn't the default behavior, allowing a preference for Execute to do both would be great.

Background

No response

Additional context

No response

[MariaJoseFF]

Hi @corycundy,

Thanks for your valuable feedback. I understand your concern since I have been an SSMS user and pressed F5 many times on auto-pilot. Unfortunately, we currently can't set up F5 to execute the entire script and the selection on Tabular Editor, but I have made a note of this request.

We currently have a couple of ways to run and apply the selected DAX on DAX Queries and DAX Scripts:

• When using a DAX Query:

  1. You can press the "Execute selection" button.
     
  2. You can use one of the Shortcuts for DAX Queries, which executes the selection: Shift+F5.

• When using a DAX Script:

  1. You can press the "Apply selection" button.
     
  2. You can use one of the Shortcuts for DAX Scripts, which applies the selection: F8.

Regarding the F5 shortcut. It is possible to Customize Shortcuts, but one shortcut can't be assigned to multiple commands. Nevertheless, a workaround you could try is to reassign the shortcut that executes the selection in a DAX Query to use "F5". The command for this is called "Editor.DaxQuery.ExecuteSelection". But then you will always need to have a selection if there is something you want to run. For example, if you want to run the whole script, you would need to press Ctrl+A and then F5 after reassigning the shortcut.

To make this reassignment, you will need to do the following:

I hope this helps!