Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
101 | |
79 | |
73 | |
65 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |