Forum Discussion
Calling snowflake stored procedure from Power Bi desktop
Hi,
Just wondering if we can call Snowflake stored procedure from Power bi desktop/service .
I am trying to write below inside SQL statement window
Call SP_SnowflakeSP( parameters);
but it's not working
If I replace above by select * from <any snowflake table? it works.
Error I am getting is
Unexpeced 'Call'.
Thanks
2 Replies
Hi RajCZ
You can consider to write it in Power query, use Value.NativeQuery() funciton. you can refer to the following link.
powerbi - How do you execute a SnowFlake Stored Procedure in Power BI? - Stack Overflow
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi RajCZ
You can now issue a SELECT FROM Stored Procedures as following:
SELECT * FROM TABLE(SP_SnowflakeSP( parameters))
More info:
https://docs.snowflake.com/en/developer-guide/stored-procedure/stored-procedures-selecting-from
