Forum Discussion
Memorable MemberA bumpy journey with .Net (beneath the semantic-link/sempy library for python)
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.
Memorable Memberv-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
Community Supportdbeavon3, 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.
- dbeavon3
v-prasare Assuming that a customer DOES have extensive experience in both Python and .Net, does the platform allow customers to host similar software architecture as what Microsoft created in this case?
Is Fabric intended to be a "flexible" Linux platform for custom solutions? Where do we get support at the OS level, if there are problems hosing our solutions in Fabric? Are we free to host any type of underlying custom libraries via python? Is there any Fabric support team that would provide OS-level support if the Linux environment itself is buggy?I have had incidents where a .net or python library will work fine in a custom on-prem environment but it fails after deploying to one of the proprietary flavors of Spark in Synapse (now Fabric).
Eg. I had an issue with the Linux configuration in the Synapse platform wherein the OS team had used a really non-standard networking configuration. (they had disabled the negative cache via "no-negcache" and this configuration created a conflict with the IP v6 traffic that was being attempted in the SQL libraries. We struggled with a tremendous amount of errors due to port exhaustion and it took many, many, many months for the Synapse support team to help with that.)Please note that there are common libraries out there already that easily enable interoperation with .net. Eg see "pythonnet". I'd guess that Microsoft wouldn't use this in sempy, but I haven't dug down to that level yet. The main callenge I see with modeling software after "sempy" is that Microsoft has not shared the code yet, and the license is probably closed. If you can direct me to a Microsoft contact for that knows anything about "sempy", then I would be able to ask follow-up questions. Barring that, I simply want to know if customers of Fabric would be discouraged from using pythonnet, because it would have no OS-level support from Microsoft (nobody to take OS-level tickets)
- v-prasare
dbeavon3, Thank you for sharing your experience with the issues you've encountered while working with MDX statements in sempy.
The details you’ve provided, including the link to the other user’s discussion, will undoubtedly contribute to a better understanding of these challenges. Your insights into the .Net interop and the XMLA/parquet libraries being used within Fabric will be helpful for further exploration and potential improvements.By bringing this to our attention, you’re not only helping to enhance our own knowledge but also contributing to improving the overall support and experience for our Fabric community.
We truly appreciate you taking the time to share your experience, and we’ll keep your observations in mind as we continue working on better solutions.
Thanks,
Prashanth Are
MS Fabric Community Support