Forum Discussion

Teige_Gao's avatar
Teige_Gao
Frequent Visitor
6 years ago

Direct Query on Dataflow

Hi all,   When can we set up the direct query on Dataflow? It looks like that all data are imported into dataset when we use dataflow.
Dataflow
Show and Tell
RakeshSinghr's avatar
RakeshSinghr
Icon for Resolver I rankResolver I
6 years ago

How do you get this option? Can you post some more snapshots pls. I have the latest may version but dont see this. All the prerequisits like premium capacity workspace dataflow, capacity setting enabled for enhanced compute engine are all set..

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Same here.

 

I even tried editing the 'Source' step in the Power Query Editor. When you press the gear-icon it lets you choose between Import and DirectQuery, but when you actually try to 'Close and Apply', you'll get the following message:

'This query contains transformations that can't be used for DirectQuery.'

 

The only transformations we do in the underlying dataflows is appending a few other dataflows. Can't find any information from MS about possible issues with the newly released feature, so curious what we're doing wrong.