Can someone provide the exhaustive list of differences between Power BI desktop Vs Datazen (illustrating the features supported, limitations of each and which one to be choosen based on the scenarios/need).
Making this list is probably a futile exercise given the rapid pace of changes in the Microsoft BI. If you are thinking to pick between the two, you may want to consider the following. If your BI strategy is bottom up - Self Service maturing to Enterprise, then Power BI is really the only way to go (Desktop) . If you are only looking at Top bottom approach, then Datazen maybe a good option. I would speculate that Datazen will disappear as a standalone option and will be eventually be incorporated into the existing BI stack but there is no official roadmap on how this will be done.
Not sure about an exhaustive list, but Power BI Desktop was built to work with the cloud-only service of Power BI 2.0.
Datazen uses an on-premises Enterprise Server similar to something like a Microstrategy.
Datazen has a richer set of visualizations, drill downs and is, in general, a more mature product than Power BI in a number of ways. That being said, they were purchased by Microsoft and whether it will remain a separate product or its technologies be woven into other product lines it is tough to say.