Calling snowflake stored procedure from Power Bi desktop

[RajCZ]

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

[сакиб]

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

[Anonymous]

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.