on 09 Nov 2018 20:57:48
Dataflows would be really useful if you could connect to them via DirectQuery. This would mean that we could query enormous dataflows that are not practical to load to the Data model and can make aggregate dataflows that we load to the Data model.
Unsure if this is possible with the architecture of a Dataflow, but it could be quite handy if it is possible.
- Comments (36)
RE: Dataflows Direct Query
It's a must!
RE: Dataflows Direct Query
Really the most important feature for 2020!
RE: Dataflows Direct Query
It's a Must i support this Idea
RE: Dataflows Direct Query
This is a very important feature to make dataflows significantly more useful.
RE: Dataflows Direct Query
Why does it not yet exist? Would be great!
RE: Dataflows Direct Query
sucks that this is not yet available
RE: Dataflows Direct Query
is there a reason why this cannot be done?
RE: Dataflows Direct Query
Including the ability to direct query your own ADLG2 should be included as well. We load our ADLG2 with ADF and Databricks and just want a dataflow to reference that content without requiring a scheduled or manual refresh, and allow it to direct query Parquet, ORC or Avro files.
RE: Dataflows Direct Query
Cannot fathom how this isn't currently an option. You have direct query, but it is only available in certain instances? What?
Perhaps someone can identify if I am doing something wrong. I have the data in an Azure SQL Warehouse and want to make the data available in a direct query (not a scheduled refresh) manner in dataflows so users can generate reports using the preset data.
RE: Dataflows Direct Query
This would be great for me, I have a massive table I want to keep in the source DB and create aggregate tables for it but I want to store some of the shared dimensions in data flows but because we can't direct query them or set them as dual then I don't have much of a use case for data flows.