Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 SP on-demand in power bi by giving an option to users to click the button and execute the SP?? Or is there way to handle this problem.
Solved! Go to Solution.
@PSan1979 , see https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow...
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
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
@PSan1979 , see https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow...
@amitchandak getting an error
DataSource.Error: Microsoft SQL: Error converting data type varchar to datetime.
Details:
DataSourceKind=SQL
DataSourcePath=desktop-tjk1uhp\san; Test
Message=Error converting data type varchar to datetime.
ErrorCode=-2146232060
Number=8114
Class=16
@PSan1979 , refer this old thread
https://community.powerbi.com/t5/Desktop/Use-SQL-Store-Procedure-in-Power-BI/td-p/20269
@amitchandak User to pass parameters (‘Store Code’,’Date1’,’Date 2’) based on the user input we need to execute the SP and fetch data
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
112 | |
96 | |
95 | |
67 | |
65 |