snowflake Stored Procedure in Power BI

[Bikramaditya]

HI community,

I wanted to get Data from snowflake Stored Procedure in Power BI , Can someone help me?

this is snowflake Stored Procedure- DATA_ANALYTICS.DA_PROC_CUSTOM_QUOTE_WIN (dtStart DATE,dtEnd DATE)

then i want to call this-

call DATA_ANALYTICS.DA_PROC_CUSTOM_QUOTE_WIN ('2021-04-01','2021-06-02');

Thanks,

Bikram

[Bikramaditya]

Thanks for the help!

[lbendlin · Accepted solution]

This should be possible via the custom SQL query option in the Snowflake connector

Put a sample query in and then replace the hard coded values with your parameters using the Advanced Editor.

[RanMan25]

Did this actually work for you?  I tried calling a Snowflake procedure "call staging.CCR_MyReport();" by placing it in the SQL statement box and it only gives me an error "The key didn't match any rows in the table."  If I put nothing there it will give me the list of tables etc so my connection is good.

[Bikramaditya123]

No, Its dose not work 

[PrachiM]

Hi,

I am facing similar challenge, any solution or step have you found. Please share