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
I'm trying to display data both sides of the Power BI directional arrow and it's resulting in the can't determain relationships error, I'm not sure why.
There are more tables but in it's simplist form, I'm trying to display data from the wiz_containers table & data from the wiz_findings table.
Wiz_containers is related to the container_images and from there Power BI should be able to get the finding data but it doesn't, I tried enabling bi-directional filtering but that made no difference.
Including data from container_images, containers & findings also errors, it's only happy when I remove the container fields.
Any tips? Thanks in advance
take a step back and reevaluate your business scenario. Based on that create a data model with dimensions and facts. Do not join fact tables directly.
Once you refactored the data model the visualization will work just fine.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
109 | |
108 | |
93 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
102 | |
86 |