Relationship issue

[AhmerZunairSqua]

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

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

[AhmerZunairSqua]

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.

[Khushidesai0109]

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!

[AhmerZunairSqua]

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 number

3. Refresh Data
yes i done that but same error

4. Verify Data in Both Tables
yes both tables contain data

5. Check for Errors in Query Editor
yes i check in querry editor it's fine and data is present i'm using Direct querry mode

[lbendlin]

Why cross filter both?

[AhmerZunairSqua]

i try with single also same issue can't detemine relationship between the fields after adding column from that table.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...