cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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.

10 REPLIES 10
Highlighted
Community Support
Community Support

Re: Direct Query on Dataflow

Hi @Teige_Gao ,

The dataflows functionality is in preview, such a requirement is not supported by now. Someone has submitted this idea here, and it is under review which might be added in the future release.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Community Support
Community Support

Re: Direct Query on Dataflow

Hi @Teige_Gao ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. More people will benefit from here.Thanks in advance.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Re: Direct Query on Dataflow

Yes every artcile on Dataflow have been grossly misleading!

They never spoke about this limitation. We were made to beleive that Reports will be able to ingest Dataflows in DirecyQuery (Live connection) manner. Whats more worse is that all Datasets now have to depend on a Dataflow to be refreshed! Make no sense to have Dataflow in the first place. I would rather load my data from my DB

Highlighted
Frequent Visitor

Re: Direct Query on Dataflow

HI,

Dataflow can be accessed with Direct Query or Import, you now habe the choice. Which is important, considering the pros and cons of both modes.2020-05-05_092246.jpg

 Didier

@dataflows 

Highlighted
Helper IV
Helper IV

Re: Direct Query on Dataflow

@Maignan , what Is the version of power bi desktop you are using?

 

Highlighted
Highlighted
Helper I
Helper I

Re: Direct Query on Dataflow

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..

Highlighted
Advocate I
Advocate I

Re: Direct Query on Dataflow

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.

Highlighted
Frequent Visitor

Re: Direct Query on Dataflow

We are considering using the Azure SQL database and Azure data lake to replace the dataflow. I think it would be a good idea.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.

Top Kudoed Authors