Forum Discussion
PSan1979
Helper II
Helper IIExecuting Stored Proc in Power BI
Hi Experts, I have a dashboard, the data is populated in the dashboard by stored procedure (SP). SP contains 3 parameters which need to pass ‘Store Code’,’Date1’,’Date 2’ Is it possible to execute...
Hi PSan1979 ,
Would you please check if the data type of parameter is the same as it in the sql database?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
amitchandak
Super User
Super UserPSan1979 , refer this old thread
https://community.powerbi.com/t5/Desktop/Use-SQL-Store-Procedure-in-Power-BI/td-p/20269
PSan1979amitchandak User to pass parameters (‘Store Code’,’Date1’,’Date 2’) based on the user input we need to execute the SP and fetch data