Forum Discussion
Relationship issue
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
I have multiple relationships in power bi and all the things are working fine now i have to do some changes in some reports for that i have to add a new table after i add and create relationship with but it says
I add new table create relationship and just use one column from that table.
It sounds like you're encountering an issue in Power BI where you've added a new table, created a relationship with an existing table, but when you try to use a field from the new table in a report, Power BI is indicating that there is no relationship. Here are some steps you can take to troubleshoot and resolve this issue:
1. Check Relationship Cardinality and Cross Filtering Directionp properly.
2. Confirm Field Data Types.
3. Refresh Data
4. Verify Data in Both Tables
5. Check for Errors in Query Editor
Try this!
Please give thumbs up or accept it as solution if it helped you!
1. Check Relationship Cardinality and Cross Filtering Directionn properly.
I check Relationship cardinality it's many-to-one and and cross Filtering both and it's fine.2. Confirm Field Data Types.
on which join both column are whole number3. Refresh Data
yes i done that but same error4. Verify Data in Both Tables
yes both tables contain data5. Check for Errors in Query Editor
yes i check in querry editor it's fine and data is present i'm using Direct querry modeWhy cross filter both?
