The first thing to make clear is that the reasons why Power BI doesn’t work properly with other semantic models are purely ...
Python has made using Microsoft Excel much easier than it has ever been, and it isn't very hard to start using it yourself.