Forum Discussion
Dataverse Synapse Link Choice Column Names
Hey, I've integrated dataverse into fabric using Synapse link to automatically bring in all the tables into Fabric. However, the choice columns in the dataverse only return the integer ID of the ...
I wrote a table-valued function that translates an integer option set lookup value into its display value. I am curious if there is an easier way to get at this without joining to the OptionSet table for each option.
Ah, i missed the optionset table! At least its possible, but also quite frustrating given the 1000s of columns we'd need to match back. Out of curiousity, what was the function you wrote?