unable to call snowflake stored procedure with Parameters from power bi

[Yashwanthsathya]

I have a storedprocedure in Snowflake which when executed gives proper results. The Storedprocedure when executed in Power BI Powerquery is giving the Data in the Powerquery in the preview. After I click "Close & Apply" i.e loading the Data to Datamodel when I add any column from the Direct Query table to any visual I'm getting the error -
Error fetching data for this visual
"DirectQuery error : DirectQuery may not be used with this datasource - please consider moving to a supported data source or upgrading the SQL Server data source to the latest available version" in the visual.

But Im able to use the columns if I load the table in Import mode. I need to bind the storedprocedure to a parameter and execute the stored procedure dynamically. 

Can anyone kindly let me know if calling the snowflake storedprocedure from Power BI is supported? Im using Power BI February 2025 version.

[Anonymous]

Hope this helps - https://community.fabric.microsoft.com/t5/Desktop/Can-i-call-Stored-Procedure-with-Direct-Query/m-p/...

[v-aatheeque]

Hi @Yashwanthsathya 
Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @Yashwanthsathya ,

We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

Thank you!

[v-aatheeque]

Hi @Yashwanthsathya ,
Have you resolved the issue? If yes, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.

Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum!