I'm working on a DirectQuery dataset in Power BI and I notice that Transform data/Query editor is disabled for DirectQuery mode, usually it'd return a message something like:
This step results in a query that is not supported in DirectQuery mode. when I tried to create a measure/new column/transform data.
What is the best way to modify data/create measures/columns when dealing with DirectQuery data?
DirectQuery comes with limitations as to what kinds of modeling and transformations you can do because the computations happen on the data source side.
Please refer to the documentation:
Given the inherent limitations, some things can be worked around but others just aren't feasible. Without specifics, I can't tell which is the case for your situation.