Error while fetching data from stored procedure in Snowflake

Hi powerbiexpert22,

Thank you  for reaching out to the Microsoft fabric community forum.

The problem is coming because Power BI Snowflake connector does not support calling stored procedures using CALL statement in the SQL box. Power BI expects a normal SELECT query, table or view. Since CALL GET_EMPLOYEE_DATA() is not a SELECT statement, Power BI is not able to read the metadata properly and Snowflake throws that compilation error. So this is not a table or permission issue, it is just a limitation from Power BI side. To fix this, you can either create a view on top of the table and use that in Power BI, or convert the logic into a table function, or simply use a direct SELECT query if the requirement is only to display table data.

Hope the above information helps you to resolve the issue. If you still have any questions or need further clarification, please let us know.
Regards,
Community Support Team.