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 MemberProbably. 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.
Community Supportdbeavon3, 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
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
- v-prasare
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.
- 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)