Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.