Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I created a paramters startdate, enddate and intervention
added query1
let
SQLSource = (StartDate as date, EndDate as date, ParmIntervention as text) =>
let
Source = Sql.Database("scccdbdev", "velos",
[Query="EXEC usp_Rpt_ProtocolOpenAccrualsByMonthRevised
NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
NULL,NULL,NULL,NULL,NULL,
'"& Date.ToText(StartDate) & "','"& Date.ToText(EndDate) & "','"& ParmIntervention & "',NULL,NULL,
NULL"])
in
Source
in
SQLSource
invoked
let
Source = Query1(#date(2019, 1, 1), #date(2020, 1, 1), "All")
in
Source
but when i save and close and edit parameter
Its not filtering based on parameter.
Please let me know if i missed anything?
Maybe the Typo: Intervetion ?
The parameters are just placeholders that you populate at run time (when you execute the query). What are you trying to accomplish?
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I am trying to populate data at report visualization level. Since the query is complicated and its a stored procedure. Trying to see if i can pass the parameters dynamically
What made you choose the "Query" option for suggested values ?
I thought this was the only option. Please let me know if there is any other option.
Thank you
It's not a bad option but it's not the only one. There are many ways to do this in Power Query. You could use text parameters, or reference tables from other sources etc.
I tried converting the Stored Procedure to view and its very difficult.
The stored procedure is very complex, with parameter present in where clause as well as joining the table.
If I start constructing the SP in powerbi it's going to be very hard.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.