Beauty:
Comes with a graphical interface, no editing domain required (no syntaxes error to ruin your day.)
Process speed is acceptable (faster than just using excel / for loop with vba, processing configuration data.)
My company is starting to use bi power for all types of reports, if you have knowledge of the power query and inserting data into bi power will be much easier.
Cons:
You have to pay, with 365 offices anyway.
Using DAX, you still need to learn syntax if you want to perform some logical process with data and preloaded tasks cannot satisfy you.
It's still slower than a python when your data is too big.
Python on the other hand is different:
Beauty:
Free, add python, and pip (numpy, pandas, matplotlib) are all free.
It's fast, like a non-clicking tool, it's fast.
Python can not only do data science, but also much more like automation in some of your daily tasks (you can use vba to do more related things but python can do more).
Cons:
You need to read the syntax (I printed the cheatsheet and placed it next to my screen when I started), sometimes spending hours searching for answers from the overflowing stack to find solutions to my questions.
Summary:
To me, if money is not an issue, and if you do not always make a new question once in a while, but just want to have one or two questions about your work, or if you do not have background information, go with a power question,
(But once you are fully able to use the power question, and have time to learn, I would suggest you learn python if you like to learn new tricks, python is not difficult and can do many things.)
if you need to manage data (especially if the data is large) always, go with Python.