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

student225
student225 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
how  you have defined the parameters ?

are you following any url for this assignment.

Author

Commented:
None, to be honest.
I came across something , tried it, didn't work and hence asking here
Database Expert
Awarded 2016
Top Expert 2016
Commented:
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
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
Question abandoned.
Provided solution

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial