3 ms·

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 th

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.

KptMarchewa 5y ago
Are you running analytics on an transactional database?
- SilverRed 5y ago
  Yes, Power BI connects up to a read only mirror of the app sql db.
  - krauses 5y ago
    Is the relational source db a denormalized star schema? Are you doing direct query or import in Power BI?
monkeydust 5y ago
OP here. Interesting as we're looking at going long with PowerBI embedded for a client facing app and ditching our home grown effort which is always playing catch-up and costs a fortune.
- Scalestein 5y ago
  I did the same thing last year for a client. So far it has worked pretty well. Client analysts create the reports and then deploy them for end users to view through a browser. End users can't do toooo much regarding playing with the data. It is slightly better than static data but the real value has been the client analysts being able to modify it without needing dev help (no JS chart libraries to mess with!)