Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a report where i am using around 50 measures everything needs to be calculated in runtime based on the date value i select. The report takes lot of time to refresh whenever i change the date filter. When i check the query analyzer it takes lot of time in the other option which means waiting for other visuals to load,
Please suggest how to improve the report performance. All the values i am displaying are dynamic values based on the date slicer so i cant move as calculated columns.
Thanks in advance
Thank you kunal. It is a 2 page report. i have made few changes in the visual location and performance for little bit ok when compare to before. But still i have the following section in report where i need to select a date and the corresponding data will display for various periods it takes lot of time and business wont wait that much time to see the results. any suggestions for this.
thanks,
Kayal Sundaram
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |