Forum Discussion
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 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.
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
5 Replies
PSan1979@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
- amitchandak
Super User
PSan1979 , refer this old thread
https://community.powerbi.com/t5/Desktop/Use-SQL-Store-Procedure-in-Power-BI/td-p/20269
- PSan1979
amitchandak User to pass parameters (‘Store Code’,’Date1’,’Date 2’) based on the user input we need to execute the SP and fetch data
v-deddai1-msftCommunity Support
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