Generally I share your skepticism, but a lot of BI tools are low-/no-code. Generally you can't build a SaaS platform on them any more than you can build it on Excel.
I deal with Microsoft’s PowerBI and it is true that somewhat normal people can do a lot but the generated result ends up extremely inefficient and we usually end up getting sql experts in to manually write the queries anyway because it costs an obscene amount for the resources to run these auto generated reports.
Don't bother with "no code" but make it a lot easier for people to write the code/markup and also much easier to edit en masse (one sed command in a Github repo, rather than editing every single dashboard separately in Tableau/PowerBI).
