cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Durgaprasad
Regular Visitor

Custom SQL Query in Snowflake DataSource

Hi Team,

 

When we connect to snowflake data source, we are not getting advanced options in the powerquery editor to pass the custom sql Query.

 

Kindly suggest alternative way to pass Custom SQL query or When can PowerBI get this feature avaialble for snowflake data source.

 

Thanks in Advance,

 

Regards,

Prasad

7 REPLIES 7
TanyoS
New Member

Hey @Durgaprasad ,

 

Recently Snowflake team realized the functionality you were looking fo.

You can check the details in the link below

https://www.snowflake.com/blog/custom-sql-now-supported-in-the-snowflake-connector-for-power-bi/

 

Tanyo

mah_priya94
Helper I
Helper I

Hi,
You can use a parameter and use the M function in the Navigation step via Advanced editor.
SAMPLE VIEW :
Create a Parameter:

mah_priya94_1-1621274095314.png

and then use Table.SelectRows directly on the end Navigation Step.

mah_priya94_0-1621274067657.png

This works because when changing the parameter, the refresh time of the dataset is very less than the actual refresh time of the complete dataset.

 

JohanEriksson
Frequent Visitor

Does anyone know if there any updates of this?

 

Snowflake has told me that it should be possible with Custom queries.

Hwever I canot see any option when I connect to Snowflake database.

Hi,
You can use a parameter and use the M function in the Navigation step via Advanced editor.
SAMPLE VIEW :
Create a Parameter:

mah_priya94_1-1621274095314.png

and then use Table.SelectRow directly on the end Navigation Step.

mah_priya94_0-1621274067657.png

This works because when changing the parameter, the refresh time of the dataset is very less than the actual refresh time of the complete dataset.

 

Evan_at_DD
Advocate IV
Advocate IV
v-shex-msft
Community Support
Community Support

Hi @Durgaprasad ,

If you can't find these options on power bi snowflake connector, it mean power  bi not support them.
BTW, I also check snowflake odbc driver related informations but I haven't found any documents mentioned send custom t-sql query from odbc driver.

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not applicable

Hi,

 

Tableau offers the option to Custom Query with Snowflake...

 

Thanks,

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors