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.
I have four tables with licensedata. I have a translation from licenseIDs to a real name in tables A and B, each using lookups in Table C. So I buit a relationship between the coloumns holding the Realname in table A+C and B+C. So far so good (I think).
Now comes to the trouble. In Tables A and B I also have identifiers for the license holder, again transöated by lookups in Table D.
Now, when I try to crate a relation for the coloumn between A+D or B+D it fails with a "loop detected" error.
Tables A and B have two coloumns (productname, LicenseHOdler) that need to related to different tables, Table C and D. Otherwise - I figure - I can't display reports that filter data in tables A and B based on a vlaue from C (or D).
How can I solve this to get report how many licenses a license-holder has?
Thx
Solved! Go to Solution.
I found out in the meantime how to work around. I tried to create relations for lookupvalue coloumns and so PowerBi was finding a circle here somewhere. I removed the LookUps and built the relations with the before-looedup coloumns. Now it works. 🙂
can you provide a screen shot of your model or better yet provide a copy of your pbix file
this sounds like a very simple set of connections to create so not sure why your having issues
Proud to be a Super User!
I found out in the meantime how to work around. I tried to create relations for lookupvalue coloumns and so PowerBi was finding a circle here somewhere. I removed the LookUps and built the relations with the before-looedup coloumns. Now it works. 🙂
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |