Pulling from Data flow - Question

[RossTheBoss]

I'm pulling in table views from SQL into a dataflow.  I'd like to write a SQL query against the dataflow instead of using Power Query.  Is this currently possible - I can't find anything on the topic.

[V-pazhen-msft]

@RossTheBoss 
You can use the sql query in the connector when add sql datasource to a Dataflow.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[mwegener]

Hi @RossTheBoss ,

this doesn't work out-of-the-box, but check out this document by Andy Cutler.

https://www.datahai.co.uk/wp-content/uploads/2021/03/Azure-Synapse-Analytics-SQL-Serverless-with-Pow...