Analyze in Excel oddity

I'm wondering if anyone else is struggling with this. I've got numeric values in my dataset that are defined as decimal and default behavior is to sum. Works well in Power BI.   If I connect to the...