Forum Discussion
Relationship issue
Taking Data from SQL on Direct Querry mode in tables and not null
i create a relationship but it say there is no relationship when i add a field in table view
many-to-one relationship
7 Replies
- lbendlinSuper User
Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
- AhmerZunairSquaFrequent Visitor
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.
- Khushidesai0109Skilled Sharer
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!