Microsoft Power BI - Run SQL Server stored procedure based on parameters


I am running sql server stored procedure from Power BI and it does bring back the results when I manually set the parameters.
However it doesn't work when I define power BI parameters and try and use them instead.
Here is what I want to do,
1. Define Power BI parameters
2. Use them in SQL statement such as,

EXEC       [dbo].[Some_Procedure]
            @Date = PowerBIDefinedParameter

Who is Participating?
Pawan KumarConnect With a Mentor Database ExpertCommented:
From this site you learn how you can pass the parameters to SQL Server Stored Procedure from PowerBI
Pawan KumarDatabase ExpertCommented:
how  you have defined the parameters ?

are you following any url for this assignment.
student225Author Commented:
None, to be honest.
I came across something , tried it, didn't work and hence asking here
Pawan KumarDatabase ExpertCommented:
Question abandoned.
Provided solution
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.