student225
asked on
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.
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.
Last Comment
ASKER
None, to be honest.
I came across something , tried it, didn't work and hence asking here
I came across something , tried it, didn't work and hence asking here
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Question abandoned.
Provided solution
Provided solution
SQL
SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.
61K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
are you following any url for this assignment.