This informative article ratings a number of the information and methods which i shielded in my webinar Overall performance Methods for Power BI Study Patterns . There are more resources and techniques, and longer grounds and sources on speech slides.
The situation
My analogy data for it speak is actually a customized Employment table from Salesforce. That it real life investigation dining table originates from a client that’s sanitized to possess privacy. New analogy possess over 382,one hundred thousand rows and this is not a giant desk to possess Strength BI. When the information is loaded toward Stamina BI, the held file size to your drive balloons to around 500MB. From inside the memory these records set occupies more than 1GB.
- Formula edits was basically sluggish
- Slicers for the records slowed down
- Renew of data grabbed extended to stream and processes the task dining table
The guidelines
What makes that it dining table unwieldy for the columnar study shop try partially the latest sequence columns, thirteen ones is more 2 hundred emails a lot of time.