Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
63 | |
56 | |
27 | |
17 | |
13 |