Forum Discussion
How to do a Direct Query from a SQL Server Stored Proc and pass Measure value as input parameter?
I have the following query definition in my Power Query - Advanced Editor:
Currently the value for the input parameter @DepartmentID is hard-coded to 'E126' as shown below:
let
Source = Sql.Database("DbServer1", "DbName", [Query="EXEC [emsdba].[des_pb_QDepartmentByDepartmentID] @DepartmentID = 'E126'"])
in
Source
I have a calculated Measure: 'QDepartment'[Measure_UserDepartment]
I want to pass the value in this measure as the value for the input parameter in the above stored procedure. Please let me know how to do this?
Anonymous you cannot pass your measure value to query, you can create parameter and can pass parameter value to query but not measure.
1 Reply
Anonymous you cannot pass your measure value to query, you can create parameter and can pass parameter value to query but not measure.