Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
My Power BI report dataset takes a long time to refresh in the service. The time fluctuates a lot ranging from 25 seconds to over 10 minutes sometimes, while the size of the data remains the same. This can be understood with the help of this log:
Start Date | Start time | End Date | End time | Time taken |
3/19/2019 | 3:00:01 PM | 3/19/2019 | 3:03:39 PM | 03:38 |
3/19/2019 | 2:40:01 PM | 3/19/2019 | 2:52:14 PM | 12:13 |
3/19/2019 | 1:40:01 PM | 3/19/2019 | 2:03:40 PM | 23:39 |
3/18/2019 | 10:35:41 PM | 3/18/2019 | 10:36:10 PM | 00:29 |
3/18/2019 | 10:32:30 PM | 3/18/2019 | 10:33:36 PM | 01:06 |
3/18/2019 | 8:47:13 PM | 3/18/2019 | 8:48:10 PM | 00:57 |
3/18/2019 | 8:44:20 PM | 3/18/2019 | 8:44:53 PM | 00:33 |
3/18/2019 | 4:00:02 PM | 3/18/2019 | 4:00:33 PM | 00:31 |
3/18/2019 | 3:50:01 PM | 3/18/2019 | 3:50:32 PM | 00:31 |
3/18/2019 | 3:40:01 PM | 3/18/2019 | 3:40:29 PM | 00:28 |
3/18/2019 | 3:00:00 PM | 3/18/2019 | 3:00:29 PM | 00:29 |
3/18/2019 | 2:50:00 PM | 3/18/2019 | 2:50:26 PM | 00:26 |
3/18/2019 | 2:40:01 PM | 3/18/2019 | 2:42:58 PM | 02:57 |
3/18/2019 | 2:00:01 PM | 3/18/2019 | 2:04:26 PM | 04:25 |
3/18/2019 | 1:40:01 PM | 3/18/2019 | 1:53:37 PM | 13:36 |
3/18/2019 | 1:09:39 PM | 3/18/2019 | 1:11:07 PM | 01:28 |
3/17/2019 | 4:00:00 PM | 3/17/2019 | 4:00:33 PM | 00:33 |
3/17/2019 | 3:50:00 PM | 3/17/2019 | 3:50:25 PM | 00:25 |
3/17/2019 | 3:40:01 PM | 3/17/2019 | 3:40:43 PM | 00:42 |
3/17/2019 | 3:00:01 PM | 3/17/2019 | 3:00:38 PM | 00:37 |
3/17/2019 | 2:50:01 PM | 3/17/2019 | 2:50:36 PM | 00:35 |
3/17/2019 | 2:40:01 PM | 3/17/2019 | 2:42:08 PM | 02:07 |
3/17/2019 | 2:00:01 PM | 3/17/2019 | 2:00:45 PM | 00:44 |
3/17/2019 | 1:50:00 PM | 3/17/2019 | 1:50:38 PM | 00:38 |
3/17/2019 | 1:40:01 PM | 3/17/2019 | 1:43:08 PM | 03:07 |
3/16/2019 | 4:00:00 PM | 3/16/2019 | 4:00:38 PM | 00:38 |
3/16/2019 | 3:50:01 PM | 3/16/2019 | 3:50:26 PM | 00:25 |
3/16/2019 | 3:40:01 PM | 3/16/2019 | 3:40:32 PM | 00:31 |
Average | 02:48 | |||
Maximum | 23:39 | |||
Minimum | 00:25 | |||
Mode | 00:31 | |||
Median | 00:38 |
How can this be resolved?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.