Hi,
I am trying to pass a parameter through SQL Statement in Power BI. I have seen some solutions similar to this question but couldn't quite adapt them so wanted to ask the question with my scenario. Below is part of the DECLARE which I want to run the parameter ie not LON but the parameter chosen; beneath this is the parameter I have set up with the BRLocation values.
Trying to keep this simple, any help greatly appreciated!
DECLARE
(there are others)
,@BRLocation VARCHAR(255) = N'LON'
Helpful resources
Join our Fabric User Panel
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Power BI Monthly Update - February 2026
Check out the February 2026 Power BI update to learn about new features.
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.
