- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Expression.Evaluate to examine value of parameter?
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You have to just say
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Perhaps Expression.Evaluate is not the right way?
Examining #share results in:
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
07-10-2024 11:26 PM | |||
06-13-2024 02:35 AM | |||
06-04-2024 03:46 AM | |||
09-01-2024 11:07 AM | |||
07-04-2019 01:52 AM |