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

Hi,

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

thanks.
student225Asked:
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
https://community.powerbi.com/t5/Integrations-with-Files-and/parameters-to-SP-or-Sql-query/m-p/58396#M4816
0
 
Pawan KumarDatabase ExpertCommented:
how  you have defined the parameters ?

are you following any url for this assignment.
0
 
student225Author Commented:
None, to be honest.
I came across something , tried it, didn't work and hence asking here
0
 
Pawan KumarDatabase ExpertCommented:
Question abandoned.
Provided solution
0
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.