Forum Discussion
JacksonAndrew
6 years agoFrequent Visitor
Power BI Dataset
When your Dataset in Service crosses 7 GB, what best practices would you recommend in Permium? Please bear in mind that my objective is the solve these challenges:- UX Performance The increasin...
nickyvv
6 years agoMost Valuable Professional
Just a quick reply that comes up: have you thought about Incremental Refresh?
- JacksonAndrew6 years agoFrequent Visitor
Sorry forgot to add. Yes, we have done that too. Not for every table but only for the fact tables.
- nickyvv6 years agoMost Valuable ProfessionalOké, so what is taking so long that it goes over 12 hours of refresh time? Is that for the dimensions? How big are they? What kind of source? Are there many PQ steps?
Can you elaborate on one of the main problems for example? The one that is taking the longest?- JacksonAndrew6 years agoFrequent Visitor
Hey nickyvv thanks and sorry for the delay. We tweaked a little bit and made the composite model work.