Forum Discussion
Relationship between Multiple Tables
Hey guys,
I'm a bit stuck in a 1-n Relationship
Im working on a bigger PowerBi report which includes some tables directly imported and a directquery to another PowerBi Dataset
1 is imported with Excel so and the other two i have connected with DirectQuery
| Table 1 | Table 2 |
| DirectQuery | DirectQuery |
| Table 3 | Table 4 |
| Imported | Imported |
The First two Tables are Connected over the _Fct Join Colum with a 1-n Relationship from Table 1 to table 2.
The Table 2 and Table 3 are connected with 1-n over the colums Startzeit and TimeList
So I'm able to get the Order Label form my first Table with Datum & Uhrzeit of my third Table.
Now i have added another Table ->Table 4
The Table 4 and Table 1 are connected with a 1-n ( Table1-Table4) Realtionship
Now in my Report i want to get all the Datum & Uhrzeit of my table 3, when i filter my Table 4 after a WZNummer.
Here are some tables with Data:
Table 4:
| Auftrag ID | WZNummer |
| 45727039 | 32568266 |
| 45727042 | 32568266 |
| 45737574 | 32568266 |
| 45737576 | 32568222 |
| 45737577 | 32568222 |
| 45737579 | 32568222 |
| 45737580 | 32568261 |
| 45744979 | 32568261 |
| 45744980 | 32568261 |
| 45747188 | 32568261 |
Table 1:
| _Fct Join Colum | Order Step Label |
| 0_1252655 | 45727039 |
| 0_1252918 | 45727039 |
| 0_1253163 | 45727039 |
| 0_1262976 | 45737574 |
| 0_1263275 | 45737574 |
| 0_1263555 | 45737574 |
| 0_1279016 | 45747188 |
| 0_1279248 | 45747188 |
| 0_1279379 | 45727042 |
| 0_1279594 | 45737574 |
| 0_1291667 | 45737576 |
| 0_1291952 | 45737576 |
| 0_1292204 | 45737577 |
| 0_1304480 | 45737579 |
| 0_1304714 | 45737580 |
| 0_1304922 | 45737580 |
| 0_1316566 | 45737580 |
| 0_1316615 | 45737580 |
| 0_1316642 | 45744979 |
| 0_1327922 | 45744979 |
| 0_1327952 | 45744980 |
Sorry for lots of this data, but i wanted to provide as much as i can.
Sincerely
Jonas
2 Replies
The Rest of my Example Data:
Table 2:
_Join Colum
Startzeit
0_1252655
29.01.2022 01:40
0_1252918
28.01.2022 19:58
0_1253163
28.01.2022 17:48
0_1262976
28.01.2022 16:19
0_1263275
26.01.2022 00:41
0_1263555
25.01.2022 22:47
0_1279016
25.01.2022 14:50
0_1279248
25.01.2022 08:26
0_1279379
22.01.2022 01:49
0_1279594
21.01.2022 19:53
0_1291667
21.01.2022 16:26
0_1291952
21.01.2022 14:48
0_1292204
21.01.2022 13:21
0_1304480
21.01.2022 10:42
0_1304714
21.01.2022 00:18
0_1304922
02.12.2021 01:22
0_1316566
01.12.2021 23:47
0_1252655
01.12.2021 22:16
0_1252918
01.12.2021 01:13
0_1253163
30.11.2021 20:41
0_1262976
26.11.2021 23:32
0_1263275
26.11.2021 01:40
0_1263555
25.11.2021 23:56
0_1279016
25.11.2021 03:18
0_1279248
23.11.2021 12:00
0_1279379
23.11.2021 09:41
0_1279594
23.11.2021 07:17
0_1291667
19.11.2021 12:33
0_1291952
19.11.2021 10:36
0_1292204
18.11.2021 09:17
0_1304480
16.11.2021 21:34
0_1304714
12.11.2021 13:18
0_1304922
11.11.2021 17:10
0_1316566
11.11.2021 14:22
Table 3:
Time List
Datum & Uhrzeit
29.01.2022 01:40
29.01.2022 01:45
28.01.2022 19:58
28.01.2022 19:40
28.01.2022 17:48
28.01.2022 17:40
28.01.2022 16:19
28.01.2022 15:50
26.01.2022 00:41
26.01.2022 01:05
25.01.2022 22:47
25.01.2022 23:15
25.01.2022 14:50
25.01.2022 14:50
25.01.2022 08:26
25.01.2022 08:15
22.01.2022 01:49
22.01.2022 02:00
21.01.2022 19:53
21.01.2022 19:30
21.01.2022 16:26
21.01.2022 16:45
21.01.2022 14:48
21.01.2022 15:16
21.01.2022 13:21
21.01.2022 13:50
21.01.2022 10:42
21.01.2022 10:25
21.01.2022 00:18
21.01.2022 00:20
02.12.2021 01:22
02.12.2021 01:20
01.12.2021 23:47
01.12.2021 23:55
01.12.2021 22:16
01.12.2021 22:15
01.12.2021 01:13
01.12.2021 01:30
30.11.2021 20:41
30.11.2021 20:30
26.11.2021 23:32
26.11.2021 23:55
26.11.2021 01:40
26.11.2021 01:15
25.11.2021 23:56
25.11.2021 23:30
25.11.2021 03:18
25.11.2021 03:40
23.11.2021 12:00
23.11.2021 12:30
23.11.2021 09:41
23.11.2021 09:15
23.11.2021 07:17
23.11.2021 07:05
19.11.2021 12:33
19.11.2021 13:00
19.11.2021 10:36
19.11.2021 11:00
18.11.2021 09:17
18.11.2021 09:30
16.11.2021 21:34
16.11.2021 22:00
12.11.2021 13:18
12.11.2021 13:00
11.11.2021 17:10
11.11.2021 17:15
11.11.2021 14:22
11.11.2021 14:00
And i want to have a table in my report which show as a result look like this:
and when i filter my WZNummer with a slicer my table should automatic filter with it
WZNummer
Order Label
Datum & Uhrzeit
32568266
45727039
29.01.2022 01:45
32568266
45727039
28.01.2022 19:40
32568266
45727039
28.01.2022 17:40
32568266
45737574
28.01.2022 15:50
32568266
45737574
26.01.2022 01:05
32568266
45737574
25.01.2022 23:15
32568261
45747188
25.01.2022 14:50
32568261
45747188
25.01.2022 08:15
32568266
45727042
22.01.2022 02:00
32568266
45737574
21.01.2022 19:30
32568222
45737576
21.01.2022 16:45
32568222
45737576
21.01.2022 15:16
32568222
45737577
21.01.2022 13:50
32568222
45737579
21.01.2022 10:25
32568261
45737580
21.01.2022 00:20
32568261
45737580
02.12.2021 01:20
32568261
45737580
01.12.2021 23:55
32568266
45727039
01.12.2021 22:15
32568266
45727039
01.12.2021 01:30
32568266
45727039
30.11.2021 20:30
32568266
45737574
26.11.2021 23:55
32568266
45737574
26.11.2021 01:15
32568266
45737574
25.11.2021 23:30
32568261
45747188
25.11.2021 03:40
32568261
45747188
23.11.2021 12:30
32568266
45727042
23.11.2021 09:15
32568266
45737574
23.11.2021 07:05
32568222
45737576
19.11.2021 13:00
32568222
45737576
19.11.2021 11:00
32568222
45737577
18.11.2021 09:30
32568222
45737579
16.11.2021 22:00
32568261
45737580
12.11.2021 13:00
32568261
45737580
11.11.2021 17:15
32568261
45737580
11.11.2021 14:00
Hi Anonymous ,
Now in my Report i want to get all the Datum & Uhrzeit of my table 3, when i filter my Table 4 after a WZNummer.
I can't reproduce your issue when using SQL Server as a data source.
Please check if you have prevent the filter.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
