Forum Discussion
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 letting me to filter a particular set of data.
10 Replies
Hi Anonymous ,
As Snowflake is essentially a foldable source, any basic operations you perform on the query in your Dataflow (basic row filters etc.) should be folded to the source, so you're not actually bringing in the whole table then filtering back again, the Dataflow will amend the query actually sent to the source to include your filters.
Pete
Hi BA_Pete : Actually I want to use a SQL rank function in snowflake query to filter the data which is not possible in PowerBI query. What I want to know is , is there a way to add a custom step which will include the sql query ?
Also, what will be syntax to add the query ?
To connect using a custom SQL query, you need to use the advanced options in the connction dialog.
When you go to connect to a Snowflake source, you should get a dialog something like this where you can expand the advanced options and enter your own SQL:
Pete
