Re: Pulling from Data flow - Question

RossTheBoss · ‎07-17-2021

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.

Anonymous · ‎07-20-2021

@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 · ‎07-17-2021

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

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Marcus Wegener works as Full Stack Power BI Engineer at BI or DIE.
His mission is clear: "Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website - podcast - Power BI Tutorials