Alternative to Nested Lookups to Bridge Unrelated Datasets

[WillHarding]

Hi,

I'm trying to find an alternative to nested lookup tables (which aren't allowed in Report Builder) that allow me to do the following:

I want to bring data from Dataset 3 into a table that initially had data from Dataset 1 in. I can create a lookup with Dataset 1 and 2, or I can create one with 2 and 3. However I cannot use a nested lookup for 1 and 3 and don't know what else is possible.

What function can I use to bridge Dataset 1 and 3?

Dataset 1

Col1	Col2
1	a
2	b
3	c
4	d
5	e
6	f

Dataset 2

Col2	Col3
a	7
b	8
c	9
d	10
e	11
f	12

Dataset 3

Col3	Col4
7	g
8	h
9	i
10	j
11	k
12	l

Much appreciated,

Will

[WillHarding · Accepted solution]

I ended up using a SQL query in Desktop to bring all of my data into a single dataset, then bringing that dataset into Report Builder. That did the trick.

[lbendlin]

Would this work ?

Table.Join(Table.Join(#"Dataset 1","Col2",#"Dataset 2","Col2"),"Col3",#"Dataset 3","Col3")