can execute function or stored procedure with parameters in Power BI direct model?

[Anonymous]

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!

[v-yuta-msft · Accepted solution]

@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