March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi, I'll be very specific here as it may be some minutae of what I'm doing that is preventing this from working.
I have two tables :- Bugs and Results. Both contain a FailureCategoryID column, but there are non unique entries in the columns in both tables. My goal is to produce a table visual that contains the Results entriers along with a BugID entry from the Bugs table that correspons to the FailurecategoryID for that entry in the results table. The Bugs to FailureCategoryID is a 1:N relationship.
So I created a bridging table in my dataset which contains all the unique values of FailureCategoryID from the Results table (Bugs table would have many many more).
The use of a bridging table has been suggested elsewhere in this support forum.
When creating the BridgingTable<->Bugs relationship, I entered the bridgingTable.FailurecategoryID first and the Bugs.FailurecategoryId second and listed it as a 1:N relationship. Ditto for the bridgingTable <->Results table.
The relationship seems to have been created OK, and is visualized as such in the relationship visual.
Then when I go to my reports tab and create a Table visual, I can add columns from bridgingTable & Bugs, or bridgingtable & Results, but never both bugs and results. It always errors out with a very non informative error of "cannot display the data because powerBI cant determine the relationship between two or more fields."
Any ideas what I'm doing incorrectly? Thanks, Dave
Hi Dave,
can you please post a screenshot of your data model?
And also the DAX you used to create the bridging table
helps us helping you 🙂
Frank
Thanks Frank. To create the contents of the bridge table, I did the following:-
@dave_blount double click each relationship and try to set its direction to "both"
should do the trick 🙂
HTH,
Frank
Thanks Frank, but that has the same error (I'd tried this already ) also the order of which table was on which side of the relationship.
Also, just to add, I did also try creatingthe bridging table via DAX (see below) and creating the relatonships then, but problem is the same.
FailureBucketUnique = DISTINCT(FailuresFromKusto[FailureBucketId])
I'm new here, so forgive me if I'm off base, but it sounds like the data structure is correct, it's the table that you're trying to produce that is causing the issues. The Bugs table entry can map back to a unique entry in the Bridging Table, but when you try to pull in fields from the Results table, Power BI has no way to know which entry to pull in as there could be multiples.
I'm struggling to visualize the table you're trying to create, what data are you trying to pull in from the reults table for each bug?
I am guessing that you have blanks in your bridge table.
Hi, I'll be very specific here as it may be some minutae of what I'm doing that is preventing this from working.
I have two tables :- Bugs and Results. Both contain a FailureCategoryID column, but there are non unique entries in the columns in both tables. My goal is to produce a table visual that contains the Results entriers along with a BugID entry from the Bugs table that correspons to the FailurecategoryID for that entry in the results table. The Bugs to FailureCategoryID is a 1:N relationship.
So I created a bridging table in my dataset which contains all the unique values of FailureCategoryID from the Results table (Bugs table would have many many more).
The use of a bridging table has been suggested elsewhere in this support forum.
When creating the BridgingTable<->Bugs relationship, I entered the bridgingTable.FailurecategoryID first and the Bugs.FailurecategoryId second and listed it as a 1:N relationship. Ditto for the bridgingTable <->Results table.
The relationship seems to have been created OK, and is visualized as such in the relationship visual.
Then when I go to my reports tab and create a Table visual, I can add columns from bridgingTable & Bugs, or bridgingtable & Results, but never both bugs and results. It always errors out with a very non informative error of "cannot display the data because powerBI cant determine the relationship between two or more fields."
Any ideas what I'm doing incorrectly? Thanks, Dave
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |