.. Your answer is correct. At the moment.
But please consider SQL vNExt, which is in CTP and will be released this year.
SQL vNExt supports Power Query!
I would add there is a concern we're running into given the Analyze in Excel feature in O365. Amounts/Values with a sigma next to them in your Fields list are not valid candidates for the Values section of the pivot table once you're in Excel. Only Measures with a calculator icon next to them in your Fields list are. So, what might be a valid candidate for aggregations in Power BI might not be available for the Analyze in Excel experience as you might imagine.