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.
It looks like a many-to-many, but I can't figure out how to get it done in Power BI.
I'm trying to link these by Name, so that I can add slicers and be able to (for example) view which trades are available in New York.
This is a simplified scenario, real data would have thousands of rows. When I attemp to link the data, I get an error saying that at least one table must have unique values.
Solved! Go to Solution.
Create a third query. Use one of your sources that has all the Names that you need and remove all other columns. Remove duplicates. Use this table to relate to each of the other tables. This is a bridge table. You will have to be somewhat careful with this as if you have information from both linked tables in the same visual it can cause problems unless you aggregate values from one of the tables. But, that is the general idea.
Create a third query. Use one of your sources that has all the Names that you need and remove all other columns. Remove duplicates. Use this table to relate to each of the other tables. This is a bridge table. You will have to be somewhat careful with this as if you have information from both linked tables in the same visual it can cause problems unless you aggregate values from one of the tables. But, that is the general idea.
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |