We provide power bi access to the data our app runs on and it has been a mixed bag. The customers absolutely love it. But they build dashboards where hitting the refresh button can bring a super expensive db to its knees for half an hour.

So then we have to get our db people in to rewrite all of their reports so they don't do this which eliminated the benefit of having the customers do it.

In the end there is just no avoiding having experts build the dashboards.