Forum Discussion
Relationships
Hello everyone. I am working on a small project using powerbi. I have 4 small tables from where I am getting data for my graphs. I created another table called Countries with the values - Netherland...
Right, so there's the evidence. All the relationships are 'both' directions.
See my previous answer.
The error is 'ambiguity between Date and Countries' so that means there would be 2 paths for powerbi to traverse between these 2 tables. This is not allowed.
I can't suggest any complete fixes without seeing the diagram but it does suggest you don't have a star schema with dimension tables filtering fact tables.
Here is a photo of the diagram.