Forum Discussion
can execute function or stored procedure with parameters in Power BI direct model?
Hi,
Does " passing parameters to stored procedure " work on Direct query in Power BI? If not, can we use function instead of store procedure? Thanks!
Anonymous ,
It's not suggested to input stored precedure in sql statement when you connect to sql database because power bi is a data analyzing tool, not a database. You should do this in the database instead.
Regards,
Jimmy Tao
1 Reply
Anonymous ,
It's not suggested to input stored precedure in sql statement when you connect to sql database because power bi is a data analyzing tool, not a database. You should do this in the database instead.
Regards,
Jimmy Tao