Executing Stored Proc in Power BI

[PSan1979]

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.

[amitchandak · Accepted solution]

@PSan1979 , see https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow...

[v-deddai1-msft · Accepted solution]

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 · Accepted solution]

@PSan1979 , see https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow...

[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]

@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