Forum Discussion
Solved
Cannot create active relationship between two tables
I have a very simple relational structure that I am attempting to build for my data model. I am using a Direct Query data source that has many tables but no built in relational model. This q...
A few questions then:
1) What is the data source you're using direct query on? If this is direct query against SSAS or a power bi dataset then what you're trying to do won't work. (Can try and explain more if that's the case).
2) If the direct query source is plain sql relationsal database then I don't understand the need for the index table? Can you explain?
3) How have you created the index table? Eg is it a calculated table or in power query.
Not many insights on this topic; people are clearly guessing. Why are relationships not more intuitive. Why doesn't Power BI list the problem 'active set of indirect relationships'?