needhelp
2 Topics
Calculation groups to replace slow IF/SWITCH?
Hi All I would appreciate your help to understand whether this idea suggested by genAI is true or a hallucination. I have a report in which the main page has many KPIs and 2 modes related to period selection, preset and custom. Preset is for predefined periods (Last 7/14/30 Days). Custom allows the user to select any date range. The switch between the 2 modes is done via bookmarks. Each KPI is represented by 2 measures, one for preset dates and another for the custom. The bookmarks are basically showing preset version of the measures and hiding the custom version or vice versa. The preset mode KPI measures use precalculated data, which makes them fast. The custom mode KPI measures use non-precalculated data which makes them slower than the preset ones. Example of measures: 1. [Builds_Triggered_preset] is used in custom mode and uses raw data. 2. [Builds_Triggered_precalculated] is used in preset mode and uses precalculated aggregated data. In the beginning, we tried to avoid bookmarks by creating parent measure that would contain an IF/SWITCH function that would decide whether it should use precalculated data or not. Example: [Builds_Triggered]= IF(SELECTEVALUE(dimDate[Period]="Custom",[Builds_Triggered_precalculated],[Builds_Triggered_preset]) When we tried this, we faced performance issues where the slower time was always recorded even when the fast precalculation logic condition was fulfilled . We suspect the IF/SWITCH function was doing eager evaluation. A ticket to the Microsoft support team didn't help either... So the bookmarks are there now to show/hide the relevant version of the measures. But these bookmarks are causing an overhead in the development as they require additional maintenance and testing all the time. MS Copilot suggested that calculation groups instead can be used instead of IF/SWITCH thus avoid the eager evaluation. Is it really possible in this scenario? and how to do that? I had a very long conversation with Copilot and I feel I'm going in circles 😐Solved2.3KViews0likes10Comments
Exporting Power BI report take too long to download
I am trying to download Power BI report using this document. https://docs.microsoft.com/en-us/power-bi/developer/embedded/export-to Report takes more than a minute to dowload successfully. How can i reduce this downloading time ?Solved4.5KViews0likes3Comments