The simplicity of managing my SQL Server instance from one place as well as being able to see what is needed in real time for any queries I run makes it very useful - especially when working remotely or with colleagues who are not familiar with certain features of SSMS/SSIS.
A bit tricky at first getting used to using this tool but once you do, its great! We use OLE DB Source components so we can easily copy over our existing database tables into PowerBI without having to manually upload each table via Excel. This saves us significant amount of time which has allowed me to focus more on other projects that need attention.