Forum Discussion

Icon for Helper II rank

Helper II

5 years ago

Solved

Executing 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...

amitchandak
5 years ago
@PSan1979 , see https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-power-bi/
v-deddai1-msft
5 years ago
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

Icon for Super User rank

Super User

5 years ago

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

PSan1979
Helper II
5 years ago
@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