Forum Discussion

JacksonAndrew's avatar
JacksonAndrew
Frequent Visitor
6 years ago

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:-

 

  1. UX Performance
  2. The increasing Dataset would hit the threshold one day.
  3. The refresh time sometimes goes beyond 12 hours.

 

A few things we have done are:-

  1. Date Intelligence
  2. Using Data Flow
  3. Used DaxStudio and optmized by eliminating unused columns, Change relationships based on memory etc
  4. Composite model - based on what are at an aggregate level and granular level.
Need Help
Tips and Tricks

4 Replies

  • nickyvv's avatar
    nickyvv
    Most Valuable Professional
    6 years ago
    Just a quick reply that comes up: have you thought about Incremental Refresh?
    • JacksonAndrew's avatar
      JacksonAndrew
      Frequent Visitor
      6 years ago

      Sorry forgot to add. Yes, we have done that too. Not for every table but only for the fact tables.

      • nickyvv's avatar
        nickyvv
        Most Valuable Professional
        6 years ago
        Oké, 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?