Forum Discussion
Cannot create active relationship between two tables
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.
There are no duplicates in the UserId so I think it should be 1:1. Even so I tried 1:* and I get this with both single and both as cross filter directions.
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.