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.
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
Solved! Go to 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.
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.
Would this work ?
Table.Join(Table.Join(#"Dataset 1","Col2",#"Dataset 2","Col2"),"Col3",#"Dataset 3","Col3")
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |