Forum Discussion

dbeavon3's avatar
dbeavon3
Icon for Memorable Member rankMemorable Member
1 year ago
Solved

A bumpy journey with .Net (beneath the semantic-link/sempy library for python)

Background: I'm trying to get a formatted string with the help of an MDX statement in sempy.  It is not as easy as I expected.  All of a sudden I'm discovering that there is some very unusual stuff g...
data engineering
  • v-prasare's avatar
    v-prasare
    1 year ago

    dbeavon3, Thank you for your continued engagement and feedback.

    we want to provide you the best possible guidance to help you achieve your goals. Microsoft has not provided any documentation or best practices for modifying or extending this bridge and we do not recommend modifying the sempy library itself or creating a custom bridge unless you have extensive experience in both Python and .NET

     

    As above mentioned, Microsoft's official support for such functionality is limited we recommend to submit your ideas here to Fabric team: https://ideas.fabric.microsoft.com/ideas/search-ideas/

     

     

    Thanks,

    Prashanth Are

    MS Fabric community support.

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

I would hazard a guess that MDX is entirely unsupported by sempy as it talks to SSAS Tabular models, in DAX.

  • dbeavon3's avatar
    dbeavon3
    Icon for Memorable Member rankMemorable Member
    1 year ago

    Probably.  But it works for all the columns on dimension tables.  It only fails for calculated measures on fact tables.  If unsupported, you might think they would generate a failure, rather than teasing us by returning some columns and not others. 

     

    ... Or maybe they would add some documentation that explains more clearly that this method ("evaluate_dax") should only be used for evaluating dax. 😉

    After digging, it appears taht they seem to be mishandling the data on the python side.  If I can get around that, and use the underlying .Net components then I should be fine.  The underlying components are probably equally capable of handling results from DAX or MDX queries.

     

    • v-prasare's avatar
      v-prasare
      Icon for Community Support rankCommunity Support
      1 year ago

      dbeavon3, Thanks for actively participating in MS fabric community


      The inconsistency you're facing highlights a gap in sempy's maturity. Your best path forward is likely to bypass sempy's Python layer for calculated measures and instead use the .Net components directly. This approach not only gives you flexibility but also ensures you're leveraging the full power of the underlying XMLA and .Net infrastructure

       

      for contributing ideas, feedabck, features and development please write here. Your feedback is important to us, Looking forward to your response.

       

      Thanks,

      Prashanth Are

      MS Fabric community support.

       

      Did I answer your question? Mark my post as a solution, this will help others!

      If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

       

       

      • dbeavon3's avatar
        dbeavon3
        Icon for Memorable Member rankMemorable Member
        1 year ago

        v-prasare 

        You said, 

         

         

        I really, really love that answer.  But I'm a bit nervous that it was copy/pasted something from chat-GPT.  Is this a real suggestion?

         

        I'd guess that it is probably the very last thing that Microsoft would be telling their customers.  They are hardly able to support "sempy" in the current form, over at the Mindtree organization.  Anything I build with .Net will be even more difficult to support. 

         

         

        Are you proposing I just unzip the python "whl" and then write a similar wrapper of my own, fo the sake of MDX queries:

        https://pypi.org/project/semantic-link/

        .. the download is semantic_link_sempy-0.8.5-py3-none-any.whl