Forum Discussion
Practicalities of Working with Large Datasets
Hi guys, just reaching out to see what people's experience is with larger PBIX models. We have a file c.750MB which we use as a master dataset. So currently we have 2 layers, a report PBIX connect...
- DAX works much better with narrower and longer tables, rather than shorter and wider ones.
- Work on reducing the cardinality of the columns
- Store date and time in separate columns
- Use integers and keys whenever possible
- Try to create a star schema if possible
- when writing measures filter dimension tables, not your fact tables
- remove any columns that you do not need or would be better off being calculated using measures
- Except if there is some complex measures you are writing, then probably best to push these to a calculated column