Hacker News Reader

Are you running analytics on an transactional database?

Yes, Power BI connects up to a read only mirror of the app sql db.

Is the relational source db a denormalized star schema? Are you doing direct query or import in Power BI?