CODEWITHSUNDEEP
powerbidirectquery
nilsinelabore
nilsinelabore

Reputation: 5095

Ways to work around DirectQuery in Power BI

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?

Upvotes: 0

Views: 4729

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40204

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.

Upvotes: 1

Related Questions