ファブリック セマンティック モデルを使用する Report1 という名前の Microsoft Power Bl レポートがあります。 ユーザーは、Report1 のレンダリングが遅いことに気づきました。 パフォーマンス アナライザーを開くと、「Orders By Date」という名前のビジュアルのレンダリングが最も遅いことがわかります。「Orders By Date」の所要時間の内訳を次の表に示します。 Report1 のレンダリング時間を最も短縮できるものは何でしょうか?
正解:C
Based on the duration breakdown provided, the major contributor to the rendering duration is categorized as "Other," which is significantly higher than DAX Query and Visual display times. This suggests that the issue is less likely with the DAX calculation or visual rendering times and more likely related to model performance or the complexity of the visual. However, of the options provided, optimizing the DAX query can be a crucial step, even if "Other" factors are dominant. Using DAX Studio, you can analyze and optimize the DAX queries that power your visuals for performance improvements. Here's how you might proceed: * Open DAX Studio and connect it to your Power BI report. * Capture the DAX query generated by the Orders By Date visual. * Use the Performance Analyzer feature within DAX Studio to analyze the query. * Look for inefficiencies or long-running operations. * Optimize the DAX query by simplifying measures, removing unnecessary calculations, or improving iterator functions. * Test the optimized query to ensure it reduces the overall duration. References: The use of DAX Studio for query optimization is a common best practice for improving Power BI report performance as outlined in the Power BI documentation.