Free: Power BI is probably going to give you everything you need. It's free, easy to use and provides a lot of features to grow into. Paid: If you have the budget, Aqua Data Studio gives you the database management functionality AND all of the visualizations you'll find in Tableau in the 1 product. (My company shifted from Tableau to Power BI. At first it seemed like a beta product with lower fidelity. But Microsoft…
Power Bi has been very abusive of my systems, although this has lessened of late. I can see hundreds of logins to my database per user, and when I cut the logins per userid to 5, their applications collapse. Their queries cannot be tuned to available indexes according to my users. They remain the very first ones that I throw off a database if there is a performance problem, with some degree of prejudice.
Under the covers Power BI is running a tabular Analysis Services Cube, so import mode will be optimized for reporting regardless of the source database indexing.
The PBI dataset can be shared across users, so only 1 connection is required to update it, instead of dozens of users hitting the db directly.
Also as another person mentioned, reporting is usually done on an separate database to production applications like an operational data store, data lake, or warehouse.