DAX and MYSQL syntax

[vacuesta]

Is there an editor in Power BI that allows you to write in both mysql syntax and DAX syntax? For example I want to use DAX syntax on MYSQL query syntax to run a query.

For example: I want to hold an array of values from a query into a variable, then use a DAX for loop to iterate through this array to feed element i into another query to produce data.

Is this possible?

[d_gosbell]

No this is not possible with DAX.

But If your model is in import mode you might be able to do something like this in the Query editor.

[vacuesta]

Hi,

Which editor are you referring to in this case?

[d_gosbell · Accepted solution]

The one when you click on the "Edit Query" button in the Power BI Ribbon.