Does " passing parameters to stored procedure " work on Direct query in Power BI? If not, can we use function instead of store procedure? Thanks!
Go to Solution.
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.
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.