Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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")
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.