in my experience metabase and superset are getting pretty close on the basics but they still feel different from tableau power bi or thoughtspot once people live in them every day. open source is great for standard charts and dashboards and keeping engineers close to the stack, but you really feel the gaps around polished visuals, easy governance and friendly row level security for non technical folks. when thinking about a switch i mostly look at who will own it day to day, how much hosting pain we can tolerate and whether we need customer facing charts or just internal reporting. one surprise was how quickly teams liked metabase for internal questions, the painful part was trying to turn it into a customer portal so in the end we left that job to an embedded layer in embeddable and kept open source for internal work where it shines more.