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!View all the Fabric Data Days sessions on demand. View schedule
Is it possible to use Expression.Evaluate to (dynamically) examine the value of a Power Query Parameter?
Trying the below results in null despite the parameter "InitFileGLOBAL" has a value.
You have to just say
Thanks! I was unclear. I want to examine value dynamically and thus select what parameter to examine based on a string value representing the name of the parameter.
The way you have done is right. Check whether InitFileGLOBAL contains a value or not in Parameter screen.
The null will come when there is no value in current value.
Thanks for your response!
I am trying to accomplish this in Power Query Online (Datamart)
When testing the same thing i Power Query for Excel it works as a charm so the question is if this is a permanent limitation in Power Query Online?
Online doesnt like the #share object or any other dynamic values in my queries (that works fine in the Excel version) so perhaps i need to rethink the design fundamentally.
Perhaps Expression.Evaluate is not the right way?
Examining #share results in:
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 10 | |
| 9 | |
| 6 | |
| 5 | |
| 3 |