PowerBI is the killer app for windows is seems. The only two things we have a windows box in our office for are powerBI and writing SD cards for windowsCE.

While it is not exactly PowerBI the only thing I have found that is similar and is on Linux is metabase[0]. It's open source and free to run locally (or self-hosted) without user limits. It can connect to multiple dbs, and allows for visual query editing as well as SQL. You can build dashboards, save SQL snippets, etc. You can even send automated emails based on query results. I hope it works for you. My company and I are very happy users.

[0] https://www.metabase.com/docs/latest/installation-and-operat...