Forum Discussion

houghtonap's avatar
houghtonap
Frequent Visitor
4 years ago
Solved

Function reference value of #shared is not the same as the actual function reference

I have run into an oddity that I cannot explain and hope someone in the community can explain the situation. My Power BI Desktop has the following items:   // SimpleFunction let result = ( ) =...
Need Help
  • houghtonap's avatar
    houghtonap
    4 years ago

    ImkeF, that is an interesting observation about what #shared returns. In doing further research, I found that #sections can also be used and it does return the original function value:

    #sections[Section1][SimpleFunction] = SimpleFunction

     This brings up another question, why would Microsoft make the return values for #shared and #sections different!? Regardless, there are now two viable solutions for retrieving the textual name for a reference value and a possible explaination why #shared and #sections return differnet values. Thanks for sharing your observation.

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
4 years ago

Hi houghtonap ,
I would be very carefull with that, as what you see in the query editor might not be the same than what is loaded into the data model or refreshed in the service.
You might want to test that thoroughly before using for actual work.
BTW: In a different file, I couldn't replicate the metadata behaviour. So if at all, I'd go for the Section function.
Very much agree that these functions should behave better 🙂