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.
Administrator on 29 Jun 2021 22:12:43
This has been released: Power BI June 2021 Feature Summary | Microsoft Power BI Blog | Microsoft Power BI
- Comments (37)
RE: Dataflows Direct Query
If a dataset can connect to datflows through live connection. It will be really helpful as we dont have to assume refresh timings and place on schedule one after other.
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.