User experience (UX) is the top priority for Microsoft in Power BI. It has incredible abilities to query data from source, such as machine learning. Query, design and reaporting is in one tool, there is no need additional tools.
It can get data from all resources, even in web site frame structure, there is no need a table structure any more. If you have unstructured data in any resource, mechine learning can recognize/learn how to capture it and get data as you wish. If a data require editing with some excel operater (mid, left, find, etc.) you don't need any more to write any command or know excel. Power BI is doing it for you with machine learning technology, you just give some example about what you need in data and it recognize/learn how to get it than populate it.
Power BI has a lots of dashboard charts, very different range, very different purpose and you can find what you need. Charts looks soo pretty and configuration soo easy too. Again! machine learning using there. If you want create a report (using a chart), you can type what you need as you talking with a friend. Power BI create it simultaneously as you writting.
Actually, there is one thing I can say that if you are working with huge data, depending on your computer configuration and only with the desktop (free) version it is little bit slow.
Best to fit your BI requirements if you not have TB level data.
Power BI is a BI, dashboard, data query and data modelling tool. You can report your data as quickly and easily as than the other competitors. With machine learning ability you can fast and easily get, querying, modelling and reporting your data. With AI supported insight ability you can drill down to the problems. If you want to more analyzing you can do it with R scripts in Power BI.