Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am getting data from an API request which requires me to include a number of parameters that are dynamic. The first one is the ID of the circuit I wish enquire on. I have set this up to allow the user to select the relevant ID so that the GET statement is updated accordingly (fldPhase2ID)
The API request changes as expected and returns the required data. I am not sure the correct terminology in terms of how the data is returned but see below
The 23860 is the ID as selected by the user, so can obviously change so I am trying to make
#"Phase to find" = Source[23860]
dynamic. I have tried the following with no luck - error message "Invalid Identifier"
#"Phase to find" = Source[Text.From(fldPhase2ID)]
I have also tried withoug the Text.From function and get the following error
BI is not my strength, so I am sure what I am trying to do is simple, but I'm certainly out of my depth. Any help appreciated
Solved! Go to Solution.
Hi @cameroon
In this case, the Source step is returning a record with a single field whose name corresponds to fldPhase2ID.
Either of these should work for the Phase to find step:
1. Return the value of the field whose name corresponds to the value of fldPhase2ID:
#"Phase to find" = Record.Field( Source, Text.From( fldPhase2ID ) )
or
2. Return the value of the first field of the record:
#"Phase to find" = Record.FieldValues( Source ){0}
I would probably recommend method 1.
Does this work for you?
Regards
Hi @cameroon
In this case, the Source step is returning a record with a single field whose name corresponds to fldPhase2ID.
Either of these should work for the Phase to find step:
1. Return the value of the field whose name corresponds to the value of fldPhase2ID:
#"Phase to find" = Record.Field( Source, Text.From( fldPhase2ID ) )
or
2. Return the value of the first field of the record:
#"Phase to find" = Record.FieldValues( Source ){0}
I would probably recommend method 1.
Does this work for you?
Regards
Hi @OwenAuger
Never tried option 2 as option 1 worked perfectly. I understand the logic of it, but know there was no way I was getting there on my own. Thanks for the help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.