Forum Discussion
Advocate IIDataflow & Direct Query to Source
Does anyone happen to know if a table within a dataflow can be configured as a direct query to the data source versus import mode? The reason I ask as we're trying to maintain regular (strong) connections in a mixed / composite model dataset. Thanks!
The initial ask was round if a data flow object could be configured as a direct query to the source content. From what I surmise, I don't believe this is possible.
14 Replies
- lbendlin
Super User
Dataflows are glorified CSV files. They have no concept of "direct query against a data source". You are already using composite semantic models - there you can implement your Direct Query components.
(Don't get me started on "Direct Query against dataflows" (aka Datamarts). I can't even. )
TSHECKELThanks. Yeah, that's our issue ... the dataset composite model we have contains DQ queries to a data source and additional "dual" connections to the dataflow. However, the use of dual through the dataflow results in weak or limited connections with the existing DQ queries. That's not the case if one omits the dataflow and uses dual to the other data sources. For some reason, data flow and dual connections result in limited connections. The thought was to get around that by possibly configuring the DQ connections through a dataflow as well.
- lbendlin
For some reason, data flow and dual connections result in limited connections.What problem are you trying to solve?
- TSHECKEL
1:N with the 1 (dual) filtering the N (direct query).
- TSHECKEL
The initial ask was round if a data flow object could be configured as a direct query to the source content. From what I surmise, I don't believe this is possible.
