27.6 Report Design
- Keep the number of visuals per page reasonable; each visual sends at least one query.
- Use drill through and tooltips to show details on demand instead of huge tables on the main page.
- Limit high-density visuals (tables with thousands of rows, maps with many points).
- Optimize › Optimization presets can switch on query reduction – e.g. slicers and filters with an Apply button so queries run only once the user finishes selecting.
- Be careful with heavy custom visuals; test their display time.
- For DirectQuery, keep the source well indexed, reduce visuals per page and consider aggregations or Dual storage mode for dimension tables.
Ravindra Bagale's Tip
Friends, many students put 25 visuals and 8 slicers on one page and then blame the model. Every visual sends queries, so reduce the visuals per page, use the Apply button on slicers, and move detail tables to drill-through pages. Clear?
Ravindra Bagale's Tip – मराठी
मित्रांनो, बरेच students एकाच page वर 25 visuals आणि 8 slicers ठेवतात आणि मग model ला दोष देतात. प्रत्येक visual queries पाठवतो, म्हणून page वरचे visuals कमी करा, slicers वर Apply button वापरा, आणि detail tables drill-through pages वर हलवा. समजलं का?
Ravindra Bagale's Tip – हिंदी
दोस्तों, बहुत से students एक page पर 25 visuals और 8 slicers रख देते हैं और फिर model को दोष देते हैं. हर visual queries भेजता है, इसलिए page पर visuals कम करो, slicers पर Apply button इस्तेमाल करो, और detail tables को drill-through pages पर ले जाओ. समझ आया?