Ways to work around DirectQuery in Power BI

0
votes

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?

1
powerbidirectquery
That is how directquery is designed to work for...you will not be able to transform data/query editor operations when using direct query mode. – balaji
Hi @balaji you're right, but I found out if you create your modelling functions as new tables, then seems like you can transform data and visualise it as per normal. – nilsinelabore

1 Answers

1
votes

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.