At the Source step, deselect AllData in the table list.

let
    Source = Excel.CurrentWorkbook(),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Name] <> "AllData")),
    #"Expanded Content" = Table.ExpandTableColumn(#"Filtered Rows", "Content", {"PRODUCT", "NAME", "SALES", "DATE"}, {"PRODUCT", "NAME.1", "SALES", "DATE"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Expanded Content",{{"DATE", type date}})
in
    #"Changed Type"
AliGW on MS365 Insider (Windows) 32 bit
A
B
C
D
E
1
 PRODUCT NAME.1 SALES DATE Name
2
 AAA Apples
100
31/01/2021
 Data_Jan
3
 BBB Bananas
200
31/01/2021
 Data_Jan
4
 CCC Carrots
300
31/01/2021
 Data_Jan
5
 AAA Apples
105
28/02/2021
 Data_Feb
6
 BBB Bananas
205
28/02/2021
 Data_Feb
7
 CCC Carrots
305
28/02/2021
 Data_Feb
8
 DDD Dates
100
28/02/2021
 Data_Feb
9
 AAA Apples
110
31/03/2021
 Data_Mar
10
 BBB Bananas
210
31/03/2021
 Data_Mar
11
 DDD Dates
105
31/03/2021
 Data_Mar
12
 AAA Apples
120
30/04/2021
 Data_Apr
13
 BBB Bananas
220
30/04/2021
 Data_Apr
14
 CCC Carrots
320
30/04/2021
 Data_Apr
15
 DDD Dates
110
30/04/2021
 Data_Apr
16
 AAA Apples
125
31/05/2021
 Data_May
17
 BBB Bananas
225
31/05/2021
 Data_May
18
 CCC Carrots
325
31/05/2021
 Data_May
19
 EEE Eggs
100
31/05/2021
 Data_May
20
 AAA Apples
130
30/06/2021
 Data_Jun
21
 CCC Carrots
330
30/06/2021
 Data_Jun
22
 CCC Carrots
300
30/06/2021
 Data_Jun
23
 EEE Eggs
105
30/06/2021
 Data_Jun
24
 DDD Dates
115
30/06/2021
 Data_Jun
Sheet: Report