Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Adding query in PowerBi Dataflow

I want to create a dataflow by connecting to Snowflake. Is there a way to directly pull the data using a snowflake query ? When i connect to snowflake database, it directly gives a table without let...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Unfortunately the Snowflake Connection dialog does not have an option to enter a query.

 

 

DokDok's avatar
DokDok
Frequent Visitor
1 year ago

i have the exact same display, different to what PETE shows.

no box to put in SQL Statement. Aug 2024

  • BA_Pete's avatar
    BA_Pete
    Super User
    1 year ago

    Hi DokDok ,

     

    The SQL statement option only seems to appear in the Desktop connection.

    My suggestion was to use Desktop to create the query required, then use Advanced Editor to copy the M code and paste that into Advanced Editor in a blank query in a Dataflow. This works for other users.

     

    Pete