Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Parameter not updating

I created a paramters startdate, enddate and intervention

roopesh_0-1597261759086.png

roopesh_1-1597261774227.pngroopesh_2-1597261791485.png

roopesh_3-1597261807386.png

 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 

roopesh_4-1597261924785.png

Its not filtering based on parameter.

 

Please let me know if i missed anything?

 

 

7 REPLIES 7
DoryO
Regular Visitor

Maybe the Typo: Intervetion ?

DoryO_0-1597352608200.png

 

mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Anonymous
Not applicable

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 

lbendlin
Super User
Super User

What made you choose  the "Query" option for suggested values ?

Anonymous
Not applicable

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.

Anonymous
Not applicable

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.

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors