Creating bins using time intervals with direct query creates unequally

[Anonymous]

See post here for more detail: https://community.powerbi.com/t5/Desktop/Bin-Groups-by-time-not-equal/m-p/542030#M254581

Changing the report from direct query to import solves the problem.

[Anonymous]

Hi

I have created a new group (bins) on a time field into 10 minute intervals. Then created a column graph with the group as the axis and legend. Clicking on the columns slices the data as expected except for a few columns. The bins that have been created are:

17:00hrs

17:15hrs

17:29:59hrs

17:45hrs

17:59:59hrs

18:15hrs

Why have the two been created that are 1 second shorter than the others? It also stops the slicing working?

UPDATE

I have changed the report from Direct Query to Import and now the bins are equal again - Is this a bug perhaps? 

[v-qiuyu-msft]

Hi @Anonymous,

I'm not able to reproduce the issue in Power BI desktop version 2.62.5222.761 64-bit (September 2018). What's your Power BI desktop version, please update it to the same version as ours then test again. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi

I am at the latest version (see below). I notice that the data you used has exact, to the second records. Try using some data that isn't so precise. And as you can see in my screen shot, the axis labels are correct but you only see the error once you hover on the column. Also are you using DirectQuery as that seems to be when the error occurs, not using import.

Feedback Type:
Frown (Error)

Timestamp:
2018-10-16T08:17:57.3563655Z

Local Time:
2018-10-16T09:17:57.3563655+01:00

Session ID:
83d8fb36-d124-45e2-a315-6bcd1ad5ca6c

Release:
September, 2018

Product Version:
2.62.5222.761 (18.09) (x64)

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461814]

[v-qiuyu-msft]

Hi @Anonymous,

Would you please share some sample data so I can try to create a table on SQL side to test it again? 

By the way, the Power BI desktop October version is released, you can try this new version 2.63.3272.40262. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi @v-qiuyu-msft

Just tried the latest October release and the problem still exists. Below is the dataset I am using - remember the error only seems to occur when using through Direct Query:

oev_id,oev_daterecorded
44,2018-10-09 17:13:45.103
45,2018-10-09 17:13:53.467
46,2018-10-09 17:14:02.143
47,2018-10-09 17:14:11.077
48,2018-10-09 17:14:46.397
49,2018-10-09 17:15:20.443
50,2018-10-09 17:15:20.610
51,2018-10-09 17:15:58.910
52,2018-10-09 17:16:01.420
53,2018-10-09 17:16:03.757
54,2018-10-09 17:16:27.390
55,2018-10-09 17:16:47.463
56,2018-10-09 17:16:55.390
57,2018-10-09 17:16:58.563
58,2018-10-09 17:17:07.633
59,2018-10-09 17:17:09.097
60,2018-10-09 17:18:24.377
61,2018-10-09 17:18:39.080
62,2018-10-09 17:19:00.543
63,2018-10-09 17:19:04.473
64,2018-10-09 17:19:31.753
65,2018-10-09 17:19:49.013
66,2018-10-09 17:20:09.297
67,2018-10-09 17:20:38.387
68,2018-10-09 17:21:00.260
69,2018-10-09 17:21:27.260
70,2018-10-09 17:21:38.570
71,2018-10-09 17:21:47.250
72,2018-10-09 17:22:02.147
73,2018-10-09 17:22:04.563
74,2018-10-09 17:22:10.093
75,2018-10-09 17:23:08.740
76,2018-10-09 17:23:31.873
77,2018-10-09 17:24:55.740
78,2018-10-09 17:25:39.480
79,2018-10-09 17:26:16.597
80,2018-10-09 17:26:26.383
81,2018-10-09 17:26:58.183
82,2018-10-09 17:27:04.270
83,2018-10-09 17:27:05.690
84,2018-10-09 17:27:11.950
85,2018-10-09 17:27:12.400
86,2018-10-09 17:27:24.270
87,2018-10-09 17:27:47.833
88,2018-10-09 17:27:52.530
89,2018-10-09 17:28:06.103
90,2018-10-09 17:28:16.197
91,2018-10-09 17:28:35.873
92,2018-10-09 17:28:47.173
93,2018-10-09 17:28:54.410
94,2018-10-09 17:29:31.857
95,2018-10-09 17:29:32.833
96,2018-10-09 17:29:48.680
97,2018-10-09 17:29:56.403
98,2018-10-09 17:30:12.830
99,2018-10-09 17:30:18.603
100,2018-10-09 17:31:00.993
101,2018-10-09 17:31:13.000
102,2018-10-09 17:31:34.480
103,2018-10-09 17:31:35.410
105,2018-10-09 17:32:13.277
106,2018-10-09 17:32:28.923
107,2018-10-09 17:33:03.950
108,2018-10-09 17:33:13.800
109,2018-10-09 17:33:23.360
110,2018-10-09 17:33:33.370
111,2018-10-09 17:33:34.033
112,2018-10-09 17:33:37.980
113,2018-10-09 17:33:38.677
114,2018-10-09 17:34:22.060
115,2018-10-09 17:34:23.667
116,2018-10-09 17:34:23.827
118,2018-10-09 17:34:49.593
119,2018-10-09 17:34:58.087
120,2018-10-09 17:34:58.827
121,2018-10-09 17:35:36.887
122,2018-10-09 17:36:11.597
123,2018-10-09 17:36:23.107
124,2018-10-09 17:36:41.020
125,2018-10-09 17:36:42.453
126,2018-10-09 17:36:59.317
127,2018-10-09 17:37:06.060
128,2018-10-09 17:37:43.713
129,2018-10-09 17:38:04.357
130,2018-10-09 17:38:17.397
131,2018-10-09 17:38:26.987
133,2018-10-09 17:39:02.450
134,2018-10-09 17:39:08.233
135,2018-10-09 17:39:17.237
136,2018-10-09 17:39:36.243
137,2018-10-09 17:39:38.723
138,2018-10-09 17:39:42.903
139,2018-10-09 17:40:01.160
140,2018-10-09 17:40:16.190
141,2018-10-09 17:40:24.860
142,2018-10-09 17:40:30.600
143,2018-10-09 17:40:56.620
144,2018-10-09 17:41:21.283
145,2018-10-09 17:41:23.940
146,2018-10-09 17:42:06.480
147,2018-10-09 17:42:08.887
148,2018-10-09 17:42:10.580
149,2018-10-09 17:42:17.770
150,2018-10-09 17:42:18.813
151,2018-10-09 17:43:14.263
152,2018-10-09 17:43:32.877
153,2018-10-09 17:43:45.620
154,2018-10-09 17:43:47.060
155,2018-10-09 17:44:13.293
156,2018-10-09 17:44:27.863
157,2018-10-09 17:44:40.803
158,2018-10-09 17:44:59.373
159,2018-10-09 17:45:08.903
160,2018-10-09 17:45:32.143
161,2018-10-09 17:45:38.793
162,2018-10-09 17:46:10.253
164,2018-10-09 17:46:28.537
165,2018-10-09 17:46:33.727
166,2018-10-09 17:46:34.180
167,2018-10-09 17:46:41.800
168,2018-10-09 17:46:46.293
169,2018-10-09 17:49:10.370
170,2018-10-09 17:49:34.290
171,2018-10-09 17:49:40.923
172,2018-10-09 17:49:51.750
173,2018-10-09 17:50:20.060
174,2018-10-09 17:50:34.853
175,2018-10-09 17:50:44.170
176,2018-10-09 17:51:02.123
177,2018-10-09 17:52:11.317
178,2018-10-09 17:52:28.553
179,2018-10-09 17:52:38.690
180,2018-10-09 17:52:50.737
181,2018-10-09 17:52:55.087
182,2018-10-09 17:53:12.663
183,2018-10-09 17:53:50.210
184,2018-10-09 17:54:11.757
186,2018-10-09 17:54:29.883
187,2018-10-09 17:54:43.630
188,2018-10-09 17:55:30.400
189,2018-10-09 17:55:55.570
190,2018-10-09 17:56:10.687
191,2018-10-09 17:56:15.243
192,2018-10-09 17:58:52.620
193,2018-10-09 17:58:59.513
194,2018-10-09 17:59:11.493
195,2018-10-09 17:59:41.170
196,2018-10-09 18:00:42.850
197,2018-10-09 18:01:01.057
198,2018-10-09 18:01:31.273
199,2018-10-09 18:01:52.793
200,2018-10-09 18:02:09.697
201,2018-10-09 18:02:34.467
202,2018-10-09 18:02:49.460
203,2018-10-09 18:02:50.310
204,2018-10-09 18:02:50.380
205,2018-10-09 18:03:06.693
206,2018-10-09 18:03:16.367
207,2018-10-09 18:03:30.973
208,2018-10-09 18:03:47.620
209,2018-10-09 18:03:55.540
210,2018-10-09 18:04:02.350
211,2018-10-09 18:04:56.700
212,2018-10-09 18:05:04.450
213,2018-10-09 18:05:20.543
214,2018-10-09 18:05:38.740
216,2018-10-09 18:08:41.310
217,2018-10-09 18:09:01.477
218,2018-10-09 18:11:19.697
219,2018-10-09 18:11:22.440
220,2018-10-09 18:13:16.167
221,2018-10-09 18:14:28.977
222,2018-10-09 18:14:32.613
223,2018-10-09 18:15:04.130
224,2018-10-09 18:15:05.917
225,2018-10-09 18:15:12.940
226,2018-10-09 18:18:11.643
227,2018-10-09 18:19:35.760
228,2018-10-09 18:20:43.260
229,2018-10-09 18:21:11.323
230,2018-10-09 18:22:17.833
231,2018-10-09 18:23:01.170
232,2018-10-09 18:24:25.230
233,2018-10-09 18:25:12.560
234,2018-10-09 18:25:52.867
235,2018-10-09 18:25:57.930
236,2018-10-09 18:26:06.413
237,2018-10-09 18:28:19.483
238,2018-10-09 18:29:06.313
239,2018-10-09 18:29:09.183
240,2018-10-09 18:29:59.667
241,2018-10-09 18:30:50.383
242,2018-10-09 18:32:07.330
243,2018-10-09 18:32:19.557
244,2018-10-09 18:33:20.603
245,2018-10-09 18:33:24.237
246,2018-10-09 18:36:32.560
247,2018-10-09 18:47:01.060
248,2018-10-09 18:48:29.407
249,2018-10-09 18:50:34.877
250,2018-10-09 19:11:17.687