Forum Discussion

Regular Visitor

9 years ago

Parameters in data import from sql server

Hi, How to pass user inputs as parameters during data import via stored procedure from sql server?

Resolver IV

9 years ago

You can set a parameter in power query.

let

sqlStatement = "

select *
from Transactions
where CustomerID = " & CustomerID //CustomerID is the name of the parameter

Source= Sql.Database("sqlserver","database",[Query=sqlStatement])

Source

The parameter can be changed by the user in power bi "edit parameter"

Regular Visitor

9 years ago

Thanks for the reply

This is the query which I'm using:

DECLARE @return_value int

EXEC @return_value = [dbo].[Stored Procedure] @startdate = &start_date , @enddate = &end_date

SELECT 'Return Value' = @return_value

It throws error saying Incorrect syntax near &"

I need to take the dates as input from the user when opening the report